Parsing a text file using logparserRSS

2 replies

Last post Apr 28, 2016 07:57 PM by JeffJohnson

  • Parsing a text file using logparser

    Jan 09, 2014 09:07 PM|Aiyaya|LINK

    Dears

    I tried to parse a text file below with a seperator "|".

    It worked well in the first line, each column is in its position, column1, column2, column3

    It's not worked in the second line, it becomes column1, column2

    Any ideas?

    thanks

    -------------

    abc|def|ghi

    abc||ghi

    -------------

  • Re: Parsing a text file using logparser

    Jun 29, 2015 09:29 AM|hg363|LINK

    I suspect because your line 1 meets your criteria = "|"

    However your line 2 dons not meet your criteria = "|"

     

    Why || seperator's in your 2nd line?

  • Re: Parsing a text file using logparser

    Apr 28, 2016 07:57 PM|JeffJohnson|LINK

    Assuming you are using -i:tsv -iSeparator:^|  then add -fixedSep:on 

    All advice is best effort, as is, no warranties, guarantees or promises of correctness. Validate everything before trusting anything.