Seems bug in tExtractDelimitedFields for | delimiter

[cdhemant]

Hello,

I am trying to split a column with | delimited string in to multiple columns. I am using tExtractDelimitedFields to split.

But when i set "|" as field separator then it gives below wrong output.

skill1|skill2|skill3|id

j|a|v|a|1

d|o|t|n|2

e|r|l|a|3

Correct output needs to be

skill1|skill2|skill3|id

java|python|go|1

dotnet|r|ruby|2

erlang|graph|cobra

My original file is as below

id;delimiteddata

1;java|python|go

2;dotnet|r|ruby

3;erlang|graph|cobra

And if i dont use | as delimiter in my file and use comma, then it works correctly

Thanks

Hemant

[manodwhb · Accepted solution]

@not specified not specified​ , use "\\|" as a field separator in tExtractDelimitedFields ,it will work.

check the below link to know more about it.

https://javarevisited.blogspot.com/2017/01/how-to-split-string-based-on-delimiter-in-java.html#:~:te....

Thanks,

Manohar

[cdhemant]

Thanks @Manohar B​  Manohar

It works

Thanks,

Hemant