« Previous Next »

• 06-10-2009, 10:57 AM

  junkone1 Joined on 06-10-2009, 2:54 PM Posts 1

  how to force the logparser to take in the date formats Reply Contact   The field 1 is in format YYYYMMDD hhmmss how can i tell it that its a dateformat so that i can use filters on it.   C:\Program Files\Log Parser 2.2>LogParser "select * from c:\temp\$AUDUSD.txt"  -i:TSV -headerRow:off -iSeparator:";" Filename            RowNumber Field1          Field2   Field3 ------------------- --------- --------------- -------- -------- c:\temp\$AUDUSD.txt 1         20090608 000025 0.797400 8000000 c:\temp\$AUDUSD.txt 2         20090608 000027 0.797400 11000000 c:\temp\$AUDUSD.txt 3         20090608 000036 0.797500 2000000 c:\temp\$AUDUSD.txt 4         20090608 000036 0.797500 2000000 c:\temp\$AUDUSD.txt 5         20090608 000036 0.797500 3000000 c:\temp\$AUDUSD.txt 6         20090608 000036 0.797500 3000000 c:\temp\$AUDUSD.txt 7         20090608 000049 0.797500 5000000 c:\temp\$AUDUSD.txt 8         20090608 000049 0.797500 5000000 c:\temp\$AUDUSD.txt 9         20090608 000050 0.797500 8000000 c:\temp\$AUDUSD.txt 10        20090608 000057 0.797500 5000000

• 07-01-2009, 8:21 PM

  In reply to

  ksingla Joined on 06-14-2006, 3:02 AM Redmond, WA Posts 845	Re: how to force the logparser to take in the date formats Reply Contact If the input type is "tsv", you can add iTsFormat to the command line. Try adding -iTsFormat:"yyyymmdd" to the commandline. Follow me on twitter at http://twitter.com/kjsingla