double quotes problem...RSS

1 reply

Last post Feb 21, 2007 06:54 AM by Anonymous

  • double quotes problem...

    Feb 20, 2007 09:29 AM|Anonymous|LINK

    the problem is that i need to strip off the double quoting around my field values.i used the -idquotes parameter... but it doesn't seem to work...anybody an idea?logfile:07-02-

    06,10:41:42,"ADMINIST","ADMINIST","",1,"1912995859"
    06,10:56:58,"ADMINIST","ADMINIST","",3,"1912995860"
    06,11:07:44,"ADMINIST","ADMINIST","",1,"1912995861"
    06,11:16:05,"ADMINIST","ADMINIST","",1,"1912995862"
    06,11:29:26,"ADMINIST","ADMINIST","",1,"1912995863"

    When I manually remove the quotes... then everything is ok...every colmn is parsed into a single colmn. when i use the idQuotes:auto option, he posts everything into one column.how can is solve this problem?

    CSV and TSV input formats

  • Re: double quotes problem...

    Feb 21, 2007 06:54 AM|Anonymous|LINK

    Please post any example queries you have tried so far and also the results of adding the -queryInfo argument.
    Running this command might help too:
    LogParser -h -i:CSV ""

    CSV and TSV input formats