Regex-Parse

[garretwalters12]

Hello, having trouble using the regex tool to parse this data. With the below data how can I make it parse to look in the table below? Thanks!

Column 1    Column 2

0	180
5	20
5	20
5	20
20	30
20	30
20	30
20	30
20	30

[echuong1]

You can use the text to columns tool with "-" as a delimiter. From there, use a data cleansing tool to remove leading and trailing whitespace, letters, and punctuation.

[garretwalters12]

Probably should have used more examples. "-" is not always the separator. Could also be "to" or just a space or anything else. Basically look for a regex to say give me the first number and second number in separate column and ignore all all other letter/punctuation/white spaces.

[echuong1 · Accepted solution]

See attached for a solution using Regex. It essentially grabs the instances of numbers, up to two instances.