So you tried something like: LogParser -h -i:TSV myfile.tsv And it reported that the Bytes field is an (I), not a (S)? I just created a simple csv file: x,num x,1 x,0 x,- x, When I do -h -i:CSV test.csv, it reports num as a string field. If I remove the - entry, then it reports num as an integer field...

I should maybe have said that the field in question was actually 'Bytes' and not 'Host' as previously suggested.

Thanks for the reply Daniel, apologies if this follow-up shows ignorance! LP thinks the value should be an integer, the preceeding values were, but instead of logging a zero or null value a hyphen character is being used and LP doesn't seem to want to replace that using to_string or replace_chr (or any...

You could use the -h command to discover what type it thinks the Host field is, or you could just TO_STRING(Host)

I'm trying to replace a '-' with a '0' to stop the 'not a relative integer' error. But now I'm getting the error: Select clause: Semantic error: 1st argument of function REPLACE_CHR must be a string Here's my query: logparser "select IP, DateTime, Request, StatusCode, Bytes, Referer, UA, Replace_CHR...

Please post any example queries you have tried so far and also the results of adding the -queryInfo argument. Running this command might help too: LogParser -h -i:CSV " "

the problem is that i need to strip off the double quoting around my field values.i used the -idquotes parameter... but it doesn't seem to work...anybody an idea?logfile:07-02- 06,10:41:42,"ADMINIST","ADMINIST","",1,"1912995859" 06,10:56:58,"ADMINIST","ADMINIST","",3,"1912995860" 06,11:07:44,"ADMINIST...

Sorry about not giving the answer, it wasn't intentional. I thought I had typed headerrow... but somehow an extra r got in there. I also didn't bother verifying the "off" vs false. Glad it is working for you.

Thanks Jeff..... you started me thinking (even before coffee!). I dug around and tried a few things. When I used this: objInputFormat.headerrow = "off" I got: E:\Logparser\testwug.vbs(9, 1) Microsoft VBScript runtime error: Type mismatch: 'objInputFormat.headerrow' So I changed it to objInputFormat.headerrow...

E:\Logparser\testwug.vbs(9, 1) Microsoft VBScript runtime error: Object doesn't support this property or method: 'objInputFormat.readerrow'