NEED HELP TO READ the textfile

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.

GGF.txt

Developer Tools

Designer Cloud

Documentation

Accepted answers

geraldo

@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

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.

Input_File-01.yxmd

All comments

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-txt-file/m-p/1144578/highlight/true#M282959

hope it helps

geraldo

@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

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.

Input_File-01.yxmd

kathbanc

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

kathbanc

Thank you all so much!.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703