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
See attached for a solution using Regex. It essentially grabs the instances of numbers, up to two instances.
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.
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.
