« Previous Next »

Thread: tab serparated W3C fields not parsed correctly

Last post 10-16-2008 12:47 PM by massel. 4 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (5 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 10-09-2008, 7:00 PM

    • massel
    • Not Ranked
    • Joined on 10-09-2008, 4:37 PM
    • Posts 7

    tab serparated W3C fields not parsed correctly

    Reply Contact

    Hello.  I have a W3C log file that is seperated with tabs.  When I run this command:                   LogParser -h -i:w3c -separator:tab hwlog

    I get the following output:

    Fields:

     LogFilename (S)
     RowNumber (I)
     date time c-ip protocol cs(Referer) cs(User-Agent) filesize filelength sc-bytes
     (S)p x-duration c-status cs-uri-stem cs-url cs-media-name cs-username

     I have been searching through this forum and banging my head against my desk for a while now.  Any help is greatly appreciated!  Mike

  • 10-14-2008, 6:19 PM In reply to

    • massel
    • Not Ranked
    • Joined on 10-09-2008, 4:37 PM
    • Posts 7

    Re: tab serparated W3C fields not parsed correctly

    Reply Contact

     So basically LogParser is not recognizing the fields correctly.  Can anybody help?

  • 10-15-2008, 2:51 AM In reply to

    • yellowdog.dave
    • Top 75 Contributor
    • Joined on 07-18-2008, 7:17 AM
    • Johannesburg, South Africa
    • Posts 84

    Re: tab serparated W3C fields not parsed correctly

    Reply Contact
    Hi, Please post a chunk of your log, or point us to a download location to take a look.
    Yes, dear

  • 10-16-2008, 11:20 AM In reply to

    • massel
    • Not Ranked
    • Joined on 10-09-2008, 4:37 PM
    • Posts 7

    Re: tab serparated W3C fields not parsed correctly

    Reply Contact

    Here you are.  You can also download the zipped file at http://hbrentals-stream.com/hwlog.zip

    Thanks much for the help. 

    #Date: 2008-10-09 01:44:25
    #Version 1.0
    #TimeFormat: UTC
    #EncodingFormat: UTF-8
    #Software: WindStorm (1.0.78.1)
    #Fields: date time c-ip protocol cs(Referer) cs(User-Agent) filesize filelength sc-bytes s-ip x-duration c-status cs-uri-stem cs-url cs-media-name cs-username
    2008-10-09 01:44:25 72.209.29.53 http http://hbrentals-stream.com/29724/townhall/vmshigh.htm Mozilla/4.0_(compatible;_MSIE_7.0;_Windows_NT_6.0;_SLCC1;_.NET_CLR_2.0.50727;_Media_Center_PC_5.0;_InfoPath.2;_.NET_CLR_3.0.04506)_(WMFSDK/11.0.6001.7000)_WMPlayer/11.0.6001.7000 309941341 7982 87865103 69.16.184.202 2252 200 /b2v2d4x3/wms/29724/20081008-095546-4.wmv http://hwcdn.net/b2v2d4x3/wms/29724/20081008-095546-4.wmv 20081008-095546-4.wmv -
    2008-10-09 02:23:11 72.209.29.53 http http://hbrentals-stream.com/29724/townhall/vmshigh.htm Mozilla/4.0_(compatible;_MSIE_7.0;_Windows_NT_6.0;_SLCC1;_.NET_CLR_2.0.50727;_Media_Center_PC_5.0;_InfoPath.2;_.NET_CLR_3.0.04506)_(WMFSDK/11.0.6001.7000)_WMPlayer/11.0.6001.7000 309941341 7982 27780985 69.16.184.202 712 200 /b2v2d4x3/wms/29724/20081008-095546-4.wmv http://hwcdn.net/b2v2d4x3/wms/29724/20081008-095546-4.wmv 20081008-095546-4.wmv -

     

  • 10-16-2008, 12:47 PM In reply to

    • massel
    • Not Ranked
    • Joined on 10-09-2008, 4:37 PM
    • Posts 7

    Re: tab serparated W3C fields not parsed correctly

    Reply Contact

    I think I finally figured it out:  the field labels seem to be separated by spaces while the data is separated by tabs.  Does that seem to be the problem?
Page 1 of 1 (5 items)
Microsoft Communities