Parsing a text file using logparser

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

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

Answer 1

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?

Answer 2

User789035500 posted

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