Need Parsing Help - column contains multiple items to parse out

[Shelley5683]

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 #1	Sequence #2	Sequence #3
12345678	89012345678	999999999

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

Thanks - Shelley

[rohanonline]

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]

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 · Accepted solution]

Try regex tool in Tokenize mode as follows:

[MarqueeCrew]

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

[Shelley5683]

Thank you very much gc - Tokenized worked!!

[Shelley5683]

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. :)