« Previous Next »

Thread: FORMAT WITH CSV

Last post 02-26-2008 6:46 AM by Yurige. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 02-21-2008, 10:55 AM

    • mahel
    • Not Ranked
    • Joined on 02-21-2008, 3:46 PM
    • Posts 1

    FORMAT WITH CSV

    Reply Contact

    Hi!

    iIt's the fisrt time that I use log Parser and I have to made a CSV file this format:

     
     ** STATISTICS FOR DAY IN MONTH  ** 
    DAYS: 30/06/2007 29/06/2007 28/06/2007 27/06/2007
    CENTRES Access Visits Access Visits Access Visits Accesos
    Lanzarote 0 0 32 7 39 6 38
    Las Palmas 0 0 75 15 71 17 103
    Tenerife 0 0 35 8 19 7 35
    Madrid 0 0 24 5 21 5 4
    Inca 0 0 62 13 52 13 77
    Manacor 0 0 34 12 56 11 60
    Felanitx 0 0 33 5 29 5 21
    Menorca 0 0 38 6 26 6 17
    Ibiza 0 0 63 12 53 12 39
    Las Palmas Prevención 0 0 0 0 0 0 0
    Alcudia 0 0 4 1 3 1 2

    For made the columns the output is -o:CSV -filemode:0 (there are diferents selects for each center) but i don't know how made the rows.

    A litte Help please.

    Thanks.
    Tags:

  • 02-26-2008, 6:46 AM In reply to

    • Yurige
    • Not Ranked
    • Joined on 12-13-2007, 3:35 AM
    • Posts 9

    Re: FORMAT WITH CSV

    Reply Contact

    It is the query result from the input file.

    If you would like you can create another csv file for input file:

    c1,c2
    2,b
    3,c

    c:\book1.csv is the file name 

    LogParser.exe "select * from c:\book1.csv" -i:csv

    Filename     RowNumber c1 c2
    ------------ --------- -- --
    c:\Book1.csv 2         2  b
    c:\Book1.csv 3         3  c
Page 1 of 1 (2 items)
Microsoft Communities