Need Parsing Help - column contains multiple items to parse out

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

Parse

Accepted answers

Try regex tool in Tokenize mode as follows:

All comments

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.

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167