Extract numbers/Special characters from a string value

Cfdiaz2103

Hi everyone!

Is there any way to take numbers or special characters from a record?

For example:

Input Data:

Column A

Tax Discount 9/100

Carlos 14.5/100 Miami

Output Data:

Column A	Output Column A
Tax Discount 9/100	9/100
Carlos 14.5/100 Miami	14.5/100

Thanks for your response.

apathetichell

try this one.

If it's always number/number there are easier ways so I wasn't sure of the complexity of what you are looking for. Takes any special character/number or period in a row and tokenizes them. If the resulting field is empty (ie a string of spaces) it will filter them out.  it filters out standalone punctuation by then searching for only strings that contain at least number.

regex special.yxmd