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?
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.
Can you provide some sample input and expected output in a file it will help us get a better understanding of the usecase.
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
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!