« Previous Next »

Thread: IIS to CSV with Text Qualifier

Last post 04-27-2006 7:51 PM by LogParser User : DEinspanjer. 2 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (3 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 04-26-2006, 8:32 PM

    IIS to CSV with Text Qualifier

    Reply Contact

    Hi

    I am using the following command line to convert an IIS log to a CSV file :

    C:\Program Files\Log Parser 2.2>LogParser "SELECT * INTO test.csv FROM ex060427.log" -o:CSV

    This works fine however I would like a Text Qualifier around certain columns.

    Any suggestions on how this can be achieved?

    Thanks in advance.

    Tecknick
    Tags:

  • 04-27-2006, 10:51 AM In reply to

    RE: IIS to CSV with Text Qualifier

    Mark as Answer
    Reply Contact
    If by Text Qualifier you mean enclosing the fields in double quotes, then the -oDQuotes: ON parameter should do the trick.

    If it is something else, all I could suggest is using String transformation functions such as STRCAT to construct your desired string.
    Tags:

  • 04-27-2006, 7:51 PM In reply to

    RE: IIS to CSV with Text Qualifier

    Mark as Answer
    Reply Contact

    Thanks Daniel

    That did the trick.

    I just looked through the chm documentation and found it.  I was previously looking under comand prompt help and could not find anything.

    Thanks a bunch.

    Tecknick
    Tags:
Page 1 of 1 (3 items)
Microsoft Communities