http://forums.iis.net/1141.aspxDiscussion of input formats such as ADS, BIN, COM, CSV, TSV, ETW, EVT, FS, HTTPERR, IIS, IISODBC, IISW3C, NCSA, NETMON, REG, TEXTWORD, TEXTLINE, URLSCAN, and W3CenCommunityServer 2007 SP1 (Build: 20510.895)http://forums.iis.net/thread/1908934.aspxThu, 02 Jul 2009 00:21:34 GMT50bcf3b4-f6fe-4638-adff-0c150e922e99:1908934ksingla0http://forums.iis.net/thread/1908934.aspxhttp://forums.iis.net/commentrss.aspx?SectionID=1141&PostID=1908934<p>If the input type is &quot;tsv&quot;, you can add iTsFormat to the command line. Try adding -iTsFormat:&quot;yyyymmdd&quot; to the commandline.</p>http://forums.iis.net/thread/1906504.aspxWed, 10 Jun 2009 14:57:52 GMT50bcf3b4-f6fe-4638-adff-0c150e922e99:1906504junkone10http://forums.iis.net/thread/1906504.aspxhttp://forums.iis.net/commentrss.aspx?SectionID=1141&PostID=1906504<p>&nbsp;</p> <p>The field 1 is in format YYYYMMDD hhmmss</p> <p>how can i tell it&nbsp;that its a dateformat so that&nbsp;i can use filters&nbsp;on it.</p> <p>&nbsp;</p> <p>C:\Program Files\Log Parser 2.2&gt;LogParser &quot;select * from c:\temp\$AUDUSD.txt&quot;&nbsp; -i:TSV -headerRow:off -iSeparator:&quot;;&quot;<br />Filename&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RowNumber Field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field2&nbsp;&nbsp; Field3<br />------------------- --------- --------------- -------- --------<br />c:\temp\$AUDUSD.txt 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000025 0.797400 8000000<br />c:\temp\$AUDUSD.txt 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000027 0.797400 11000000<br />c:\temp\$AUDUSD.txt 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000036 0.797500 2000000<br />c:\temp\$AUDUSD.txt 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000036 0.797500 2000000<br />c:\temp\$AUDUSD.txt 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000036 0.797500 3000000<br />c:\temp\$AUDUSD.txt 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000036 0.797500 3000000<br />c:\temp\$AUDUSD.txt 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000049 0.797500 5000000<br />c:\temp\$AUDUSD.txt 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000049 0.797500 5000000<br />c:\temp\$AUDUSD.txt 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000050 0.797500 8000000<br />c:\temp\$AUDUSD.txt 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20090608 000057 0.797500 5000000</p>