the separator is in the text - large set of data

[Cesc]

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

a|aa|bbbb|cccc|dddd (in this line, the first string is a|aa, and it should not be separated).

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,

[AngelosPachis]

Hi @Cesc ,

Can you provide us with more info about how you're importing the data within Alteryx? What's your file type? Is it a.txt file?

[Cesc]

Correct, it's a .txt

[atcodedog05]

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 : )

[T_Willins]

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.

[Alteryx_AR]

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