logparser "select UTCtime,Localtime INTO C:\a.tsv FROM C:\temp\TraceSink.log" -i:TSV -iSeparator:"|"
-iHeaderFile:"c:\temp\TraceLogHeader.tsv" -nSkipLines:2 -iTsFormat:"yyyy-MM-dd?hh:mm:ss"
Error: SELECT clause: Syntax Error: unknown field 'UTCtime'.
The closest match for input format 'TSV' is 'UTCtime,Localtime,EventID,EventType,ComponentDoingTheLogging,ComponentCausingTheLogging,
UnknownField,ProcessID,ThreadID,Message,ExceptionDetails'
c:\temp\TraceLogHeader.tsv:
------------------------------------------
UTCtime,Localtime,EventID,EventType,ComponentDoingTheLogging,ComponentCausingTheLogging,UnknownField,ProcessID,ThreadID,Message,ExceptionDetails
If I use the same command line above to read the same altered TraceSink.log file (using "," commas as delimiters instead and using :CSV as input format) the results are successful.
However, the original file: "TraceSink.log" uses "|" as a delimiter, hence my choice of using TSV format which gives me the "iSeparator" option.
Any ideas?
Thank you.