topic Seems bug in tExtractDelimitedFields for | delimiter in Talend Studio

Seems bug in tExtractDelimitedFields for | delimiter

cdhemant — Tue, 04 Aug 2020 05:01:04 GMT

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 — Tue, 04 Aug 2020 05:43:58 GMT

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

check the below link to know more about it.

Thanks,

Manohar

cdhemant — Tue, 04 Aug 2020 05:52:54 GMT

Thanks @Manohar B Manohar

It works

Thanks,

Hemant