Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Text to column

AbdullahMansour90
7 - Meteor

Hello all, I have a txt files with no delimiters as in the photo, what is the best way to upload and parse the data to columns in that case? thanks in advance. 

 

AbdullahMansour90_0-1613676656839.png

 

 

4 REPLIES 4
pedrodrfaria
13 - Pulsar

Hi @AbdullahMansour90 

 

Can you provide what you would like the output to be?

 

If it is to separate these columns, can't you use a space as a separator?

 

Pedro.

AbdullahMansour90
7 - Meteor

Hi @pedrodrfaria 

 

I want the data to be parsed into columns, each one ends with the first space, i tried to do it with spaces, but number of spaces in not consistent across rows so it messes up the columns. 

pedrodrfaria
13 - Pulsar

If I understood it correctly, then using \s+ as a delimiter in the Text to Columns tool will solve your problem.

 

If possible, paste here the data, and we can use it in a workflow to show you.

Maskell_Rascal
13 - Pulsar

Hi @AbdullahMansour90 

 

I'm guessing that the screenshot you provided is how your data looks when you open the .txt file outside of Alteryx.

 

Kinda like this:

Maskell_Rascal_0-1613681351975.png

 

And when you input it to Alteryx with no delimiters, it look like this:

Maskell_Rascal_1-1613681405406.png

 

If this is the case, you can first do a data cleanse to remove duplicate whitespace between each column, and then use the Text to Columns tool to split to 3 columns. 

 

Data Cleanse:

Maskell_Rascal_2-1613681504374.png

 

Output after Text to Columns:

Maskell_Rascal_3-1613681542153.png

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Thanks!

Phil

 

 

Labels