How to align columns in text format

[Sshasnk]

Hi, I have a dataset that is in text format but once I load it in alteryx the alignment becomes pretty messy. Is there a proper way to load text data in alteryx

attached the sheet,

Expected output:

I always have to pick the first one from the text, for example below 1 st record (9856452EX)Apple was the first so I picked the apple and not mango.

And also I have picked the quantity of apple

Code of the product	Product	Quantity	Total Quantity	Currency
9856452EX	Apple	5	25	USD
956874FX	Mango	5	25	USD

[PhilipMannering]

Difficult to say @Sshasnk  without seeing the file. It shouldn't come in misaligned! I don't suppose you share any of the data or at least a screenshot of the txt file?

[Sshasnk]

@PhilipMannering updated 

[AkimasaKajitani]

Hi @Sshasnk 

Here is the solution for you.

Result:

Your data is not simple, so you have to parse the data.

1.I used the RegEx tool to parse the each data.
2.I used the Multi-Row formula tool to separate the each record.
3.I used the Transform and CrossTab tool to put parsed data into each record.

Please refer attached Workflow.