txt file without delimiter

[nilashiwers]

Hi, I have these strings and I need to split them in order to obtain the 5th column with numbers.

How can I do it? 

[atcodedog05]

Hi @nilashiwers 

Can you provide some sample input and expected output in a file it will help us get a better understanding of the usecase.

[Luke_C]

Hi @nilashiwers 

Agree with @atcodedog05, data would be helpful. At first glance you may be working with a fixed width text file. Here's an article that might help:

How to read in fixed width files - Alteryx Community

[nilashiwers]

Sorry, here is the sample input and expected output file.

I'm beginner with alteryx, I tried to find some articles but didn't find the solution for my case.

Thank you!

[Luke_C · Accepted solution]

Hi @nilashiwers 

Here's my initial pass at this. I'm struggling to break out the Dare/Avare fields, but hopefully this gets you in the right direction.

[nilashiwers]

Thank you!