Start Free Trial

Alteryx Designer Desktop Discussions

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

Need Parsing Help - column contains multiple items to parse out

Shelley5683
7 - Meteor

I have the following data and need to separate just the numbers into 3 different columns. I used the RegEx tool with (\d+) as my expression and parse, this will move the first set of numbers to a column but I can't repeat this for the other 2 sets. Please help!

 

Example: This is the beginning data I'm using (in one column, can be multiple rows with different sets of numbers and not always separated with a character).

Use 12345678, 89012345678, 999999999 for best results

 

Results I want:

Sequence #1Sequence #2Sequence #3
1234567889012345678999999999

 

I appreciate any assistance that you can provide or let me know if this is not possible.

 

Thanks - Shelley

6 REPLIES 6
rohanonline
10 - Fireball

You may try to use text to columns tool with comma (",") as a delimiter. In case you are expecting different delimiters, use multiple tools with all the possible delimiters (including space) and it should work then.

Shelley5683
7 - Meteor

The data isn't always separated by a comma and this varies on how I get this information. It may have the numbers at the front, end or in the middle of a sentence. 

gc
9 - Comet

Try regex tool in Tokenize mode as follows:

regex_tokenize.png

 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

Shelly, do you have a limit for the count of values that you are receiving?  If you use the REGEX PARSE tool, you can create rows of your values.

 

First add a record ID to the input and then use the RegEx parse tool configured as:

 

Expression:  \d+

Output Method: Tokenize

 

You can split to columns with a predefined # or split to rows.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Shelley5683
7 - Meteor

Thank you very much gc - Tokenized worked!!

 

Shelley5683
7 - Meteor

Mark, there is not a limit on the number of rows, sometimes just a few others may be thousands. I will keep this in mind though if we need to separate out rows. :) 

Labels
Top Solution Authors