You are missing the parameter for the objInputFormat that matches -headerrow:off : objInputFormat.readerrow = "off" I believe will work. (you include the one for outputFormat only).

The fundamental flaw in the original approach is the fact that csv files are not the same as text files. If you want it to act like one, then use -i:textline . Otherwise see Daniel's reply.

Thanks - I tried it with changing it to "off" as well as remarking out the line altogether. Same thing.....

just guessing but objOutputFormat.headers=False probably should be objOutputFormat.headers="off" as it is really not a boolean field. Hope this helps. Stan

I am attempting to read a TSV file and output CSV using a vbscript. I have manually tested the script outside of vb and it works but when I try it in the vbscript I get an error about not recognizing field 1. I narrowed it down to what appears as an issue with the TSVInput Format. Here is my vbscript...

The CSV input format won't have a column named "Text" unless you explicitly made one. Try running: LogParser -h -i:CSV \\h505050\c$\book1.CSV to see what column names and types LP parses from your CSV file.

Please can some one advise me. I have an excel file which I have resaved as a .csv file. However when I run this query "-i:CSV -o ATAGRID " & """SELECT TEXT FROM \\h505050\c$\book1.CSV WHERE Text LIKE '%Microsoft Windows XP Professional%'""" Logparser is not returning any data, is there some thing...

[QUOTE User="LogParser User : StanL"]Quote: You could try setting the maxStrFieldLen on your SQL output format.[/QUOTE] Bingo! Thank you.

You could try setting the maxStrFieldLen on your SQL output format.

[QUOTE User="LogParser User : StanL"]Quote: I would expect the iTsFormat option to work for you, but maybe you could try setting DTlines to 0 to turn off automatic type parsing.[/QUOTE] No, it appears to have no effect. I did set oInput.dtLines=0 and then SQL such as SELECT TO_TIMESTAMP( REC_DATE, 'MMddyyyy...