Figured it out...

Greeting all, I'm a total newb to LogParser and coding in general so go easy on me for this basic question. Anyway, I have a file that is generated by a Perl script to analyse software license usage every 10 minutes. The format looks like this: DateTime, Pkg1, Pkg2, Pkg3 --------- ----- ----- ---- Mon...

We are the Company who is offering all the solution for VOIP and ITSP Services. Now we are offering Pakistan DIDs at very low cost. in just 10 USD Per DID and minimum purchase 10 DIDs. ------------------------------ No Setup Fee No Hidden Charges Unlimited incoming Calls Map to anywhere ------------...

I have a CruiseControl.Net project that runs LogParser on perfmon CSV logs every 5 minutes and sends the data to a database, and saves the checkpoint file. I added some counters to the perfmon counter collection, so this resulted in new columns in the CSV file. The Logparser job then messed up and did...

Daniel, Thank you so much. Your suggestion worked perfectly! Using the COALESCE function I was able to replace the NULL entries with a customer alias and now the query is working great. Thanks so much!!!

If your csv has empty bare fields, those are in fact nulls. You can test that by putting a "WHERE [Field_Name] IS NULL" clause in your query. If your fields were quoted, then they would be empty strings. You would see those by putting a "WHERE [Field_Name] = ''" clause in your query. If you want to replace...

Hi All, I am new here and to LogParser so please be gentle. I am attempting to use LogParser to create a chart from an authentication log which is CSV. I have the query counting all of the unique values in a specific field, and the output is a nice little graph chart. In this specific field there are...

Daniel, you rightly deserve your 'supreme being' status! I had looked at -dtlines in the help file and not understood what it was doing. Thanks ever so much. D

Foolish mistake on my part. I should have had more rows. When I used your example input, and queried on SELECT * FROM test.csv, I noticed that it doesn't even return row 12 (the one with the -). If I set allowed parsing errors to zero -e:0 then it aborts on row 12. Unfortunately, I'd say what you need...

Thanks again for looking at this Daniel. I amended your test.csv to include a few more previous instances of an integer: x,num x,9 x,8 x,7 x,6 x,5 x,4 x,3 x,2 x,1 x,0 x,- x, LP then reports that the num field is an integer. And won't allow me to replace the non-integer with zero.