Parsing a text file using logparserRSS

• • Reply
  Aiyaya

  1 Post

  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

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

• • Reply
  hg363

  62 Posts

  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?

• • Reply
  JeffJohnson

  13 Posts

  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.