locked
Parsing a text file using logparser RRS feed

  • Question

  • User626967155 posted

    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

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

    Thursday, January 9, 2014 9:07 PM

All replies

  • User1504639868 posted

    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?

    Monday, June 29, 2015 9:29 AM
  • User789035500 posted

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

    Thursday, April 28, 2016 7:57 PM