HOW TO PARSE PIPE DELIMETED text file

[kathbanc]

Hi Good Day!!!  

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

thank you in advance.

[sparksun]

Check this thread and see if it work

Solved: Cannot Parse Pipe Delimted File - Alteryx Community

[kathbanc]

Hi!

already read that post and it doesnt worked for me :( 

[Qiu]

@kathbanc 
Can you provide sample input data?
And I dont see the Pipeline delimiter in your first screenshot/

[kathbanc]

Hi!, 

this is the sample file. header name starts at line 6. 

[ArnaldoSandoval]

Hi @kathbanc 

I can't see the pipes ( | ) in the file you uploaded ☹️

Arnaldo

[sparksun]

It seems your sample file is not pipe delimited, you can try use \t as delimiter,start data import on line 8 to check if it is what you want.

[kathbanc]

i also tried the tab delimited, error is : Too many fields record. 

[ArnaldoSandoval · Accepted solution]

Hi @kathbanc 

I had no problems reading the file, but you should have a better understanding of the data your about to process with an Alteryx workflow, as the file is tab separated and the data columns are defined at row 8, once you load the data, there are still more cleansing to be done, which seems to be straight forward.

Good luck,

Arnaldo

[kathbanc]

Thank you all so much!!