tExtractDelimiterFields not working for data from tMySqlInput

[Anonymous]

i am retrieving a data from a table which has pipe "|" seperated data. I need to extract the data into different fields. I tried using tExtractDelimiterFields; but it is seperating the data per character. 

My data is 5203011|ABC||DirectPartner|Active

I need it extracted by | seperation into 

5203011

ABC

DirectPartner

Active

 

[Anonymous]

Hello,

Could you please post your tExtractDelimiterFields schema setting screenshot on forum?

Best regards

Sabrina

 

[Anonymous · Accepted solution]

Hi Sabrina,

I figured out the issue. Thanks.

I had to use "\\|" instead of "|" as the seperator.

[Anonymous]

Hello,

Great this issue has been fixed by yourself. Thanks for your feedback.

Best regards

Sabrina