We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Parse data based on numbers and characters spaced unequally

bizimran
7 - Meteor

Any help on getting the following data parsed? Please note that the space between the items is not equal, output will have six column and the last item in the last row (29.01) should go to the last cell of resultant table (in same column as 1461.811).

 

7-030 FLAT-YTO/BUNNY     25        492.374         1,232.382        8,049.505
8-011 SQUARE-FRUITY-LEVEL           26            939.90          8,140.686          1,461.811
9-02 ROUND-COMPN SERVICE    27                                                                 29.01
1 REPLY 1
mbarone
16 - Nebula
16 - Nebula

What would you like the output to look like?  

Labels
Top Solution Authors