Five Stars

tExtractDelimiterFields not working for data from tMySqlInput

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

 talend.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Five Stars

Re: tExtractDelimiterFields not working for data from tMySqlInput

Hi Sabrina,

I figured out the issue. Thanks.

 

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

 

 

3 REPLIES
Moderator

Re: tExtractDelimiterFields not working for data from tMySqlInput

Hello,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: tExtractDelimiterFields not working for data from tMySqlInput

Hi Sabrina,

I figured out the issue. Thanks.

 

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

 

 

Moderator

Re: tExtractDelimiterFields not working for data from tMySqlInput

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.