txt file Space Separated Delimination Not working

[nnakhawa]

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

[Qiu · Accepted solution]

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

[nnakhawa]

Thanks for your easy solution !

[nnakhawa]

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

 

[KGT]

Great solutions by both @Qiu & @GaneshBo.

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.