the separator is in the text - large set of data

Question

Hello!

I have a large set of data separated by "|". Once importing it, Alteryx tells me there are too many fields. Observing the situation, i have realized that it is because there is the character "|" inside  of a field. For example

AAA|BBB|CCC|DDD

a123|b123|c123|d123

Its such a large set of data that it is impossible to change it manually. How could I tell alteryx to get the right separator "|".

Thank you,

Alteryx_AR · Answer

Hi @Cesc-

I am also a user of same type of datasets . While importing following configuration helps you to get data in correct format-

If you want to use text input following is the method that I know-

Hope my solution helps you. If yes , please mark as accepted solution.

Thanks

T_Willins · Answer

Hi @Cesc,

What is the actual rule for determining if a | is part of the string or a separator?  Your sample data makes it easy to find a solution, but this may not match your actual data.

atcodedog05 · Answer

Hi @Cesc

Your analysis is correct it is because there is the character "|" inside of a field.

Make sure to read with below config

Here is how you can do it

Hope this helps : )

txt file issue.yxmd