Home IIS.NET Forums Logparser Forums Input Formats Parsing a text file using logparser
Last post Apr 28, 2016 07:57 PM by JeffJohnson
1 Post
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
62 Posts
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?
13 Posts
Apr 28, 2016 07:57 PM|JeffJohnson|LINK
Assuming you are using -i:tsv -iSeparator:^| then add -fixedSep:on
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
-------------
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?
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