IIS logparser output format issue

[rhitam30111985]

Hi all , i am using logparser 2.2 to reduce the number of repetative errors from master log file . the syntax of my query is somewhat like this :



logparser -i:TSV -o:TSV -q:on -fixedsep:on -oCodepage:65001 " select.... from master.log " >somefile.txt

now as per the flag .. the output of the file somefile.txt should be utf-8 ... but when i open the file in notepad and goto file--> save as . . .the default value shown is ansi . The reason why i want this in utf-8 format is because i will be performing further queries on this somefile.txt to genererate further filtered reports ... but when i do that ... it returns some junk characters in the somefile.txt file



example :

logparser -i:TSV -o:TSV -q:on -fixedsep:on "select a,b,c from somefile.txt where(...) " > anotherfile.txt



at this point the errror given is :

Error: SELECT clause: Syntax Error: unknown field 'a'.
The closest match for input format 'TSV' is 'a'.

ie .. some junk characters followed by the actual column name ...



I cant figure out what could possibly be the error ...

would immensely appreciate any help ..





regards ,

rhitam

[kenobewan]

For support MS send you to www.logparser.com. HTH.