Txt format to csv

Jaganmohan

Hi,

Could you please help me out on giving perfect alignment (text to column ) to below mentioned txt file.

I need to present the data below mentioned format (Fields) in csv.

S.NO SM HOLD TYPE ISSUE CURR CNTRY CHANGE VALUE VALUE ID DATE TIME

Thanks in advance.

2022-02-03-0201.txt

Datasets

Input

Accepted answers

All comments

mbarone

Have you tried the fixed width input option? You can manually place your field breaks:

2022-02-22 08_27_33-Alteryx Designer x64 - New Workflow1_.png

2022-02-22 08_27_21-Flat File Layout.png

Jaganmohan

Hi - I am tried but its(fixed width) not working.

mbarone

How is it not working? I got it to work. It's not pretty, and you'll have to do a lot of data manipulation to get it how you want it (probably some filter tools, multi-row tools, formula tools, etc.), but that's usually the case with fixed width. That's why if at all possible, I try to talk to the owners of the report and see if we can get a data file in CSV format or something else. But sometimes that's just not possible and you have to work with the fixed width format.