We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

How to select from a CSV fileRSS

1 reply

Last post Jun 22, 2004 08:25 AM by Anonymous

  • How to select from a CSV file

    Jun 22, 2004 02:43 AM|Anonymous|LINK

    The format of logfile.csv is:

    ID,IPLength,Version,TOS, ...
    318,20,4,0, ...
    319,20,4,2, ...
    320,20,4,1, ...

    etc...

     

    CSV and TSV input formats

  • Re: How to select from a CSV file

    Jun 22, 2004 08:25 AM|Anonymous|LINK

    "SELECT ID, IPLength, Version, TOS FROM myfile.csv" -i:CSV

    or

    "SELECT * FROM myfile.csv" -i:CSV

    If you want to see how Log Parser detects the field names and types, do:

    logparser -h -i:CSV myfile.csv

    and you'll be able to see the list of field names and types.

    ------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

    CSV and TSV input formats