Text to column

[AbdullahMansour90]

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. 

[pedrodrfaria]

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]

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]

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]

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:

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

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:

Output after Text to Columns:

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

Thanks!

Phil