« Previous Next »

Thread: Parsing a Text file with no limters

Last post 01-22-2009 7:31 PM by Rovastar. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

  • 01-22-2009, 6:24 PM

    Parsing a Text file with no limters

    What I would like to do is take the file below and parse it into a CVS file or excel. Is it possible with log parser? 

    I have a text file like this

    ***XX1234 X1234567 XX XXXXXXXX 1
     
    Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text.

    ***XX1234 X1234567 XX XXXXXXXX 1
     
    Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text.

    ***XX1234 X1234567 XX XXXXXXXX 1
     
    Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text.

    ***XX1234 X1234567 XX XXXXXXXX 1
     
    Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text.

     

     

  • 01-22-2009, 7:31 PM In reply to

    Re: Parsing a Text file with no limters

    Probably not, no.  Log Parser basic is just a SQL engine to work on log files. It is better top do this in code rather than attempt it under SQL which will need feilds.

Page 1 of 1 (2 items)
Microsoft Communities