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
Solved! Go to Solution.
Could you please post your tExtractDelimiterFields schema setting screenshot on forum?
Great this issue has been fixed by yourself. Thanks for your feedback.