txt file Space Separated Delimination Not working

Text To column tool with delimitators '/s' or '/0' not working for attached .txt file.
Is anyone have another solution to direct get separated columns without actually looking into fields in designer.
I am able to do in excel for space eliminator using text to column, but not working in Alteryx

Memberlist (1).TXT

Text Mining

Accepted answers

Qiu

@nnakhawa
Because there are multiple spaces between each column we better to bring the data as one column then do the processing as below.

0826-nnakhawa.yxzp

All comments

Qiu

@nnakhawa
Because there are multiple spaces between each column we better to bring the data as one column then do the processing as below.

0826-nnakhawa.yxzp

nnakhawa

Thanks for your easy solution !

nnakhawa

Received another solution From Ganesh Bo San using Regex replace in formula tool. Sharing for another approach.

Screenshot 2024-08-26 135824.png

nnakhawa_soltn.yxzp

KGT

Great solutions by both @Qiu & @GBO95.

Here is another solution that allows spaces to be in the data. It's based on the file being evenly spaced which it appears to be. In this, we use the header row to work out the character numbers for each field and then append those to the data (12 fields and so the number of records multiplies by 12. To avoid that a macro would be needed).

Then run the substring and crosstab the data back to a table.

txt file character delimted.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703