NEED HELP TO READ the textfile

[kathbanc]

Hi Good Day!!!  

I am having trouble parsing the file. I have a 54 column text file that I am trying to read but it keeps coming in as one column if I tried the pipe delimited .  Already change the option # 2 to ( | ). 

But when I use the \t ( tab delimited) error message is " Too many fields" 

Attached is the sample file

thank you in advance.

[caltang]

Have you tried /0 as a delimiter? Then use Text to Columns tool to split it accordingly. 

[caltang]

Another method I recommended to another user: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Text-to-column-unstructured-tx...

hope it helps

[geraldo · Accepted solution]

@kathbanc 

This is the file you uploaded. and the delimiter is \t and the data starts at line 8

and there are columns that have no name as in the print

[ArnaldoSandoval · Accepted solution]

Hi @kathbanc 

Somebody posted a similar question with exactly the same file you uploaded, the file as @geraldo described does not have pipes,

I am attaching the workflow that is reading the file on my side,

Arnaldo.

[kathbanc]

It works T_T ,  The line start at line 8 T_T . thank you thank you! 

[kathbanc]

Thank you all so much!.