Connecting Tech Pros Worldwide Forums | Help | Site Map

IIS logparser output format issue

rhitam30111985's Avatar
Member
 
Join Date: Aug 2007
Location: bangalore, india
Posts: 111
#1: Sep 26 '08
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's Avatar
Moderator
 
Join Date: Dec 2006
Posts: 4,745
#2: Sep 27 '08

re: IIS logparser output format issue


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


Similar IIS / Microsoft Internet Information Services bytes