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

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.

[mceleavey · Accepted solution]

Hi @Cfdiaz2103 ,

I've built a little regex magic:

([^a-z\s]+)

M.

[Cfdiaz2103]

Hi @mceleavey !

You nailed it, bro!

Thanks in advance.

[mceleavey]

[Cfdiaz2103]

@apathetichell That was cool. It perfectly worked!

Thanks!

[apathetichell]

Good to hear - but @mceleavey 's solution was definitely more awesome. Regex tokenize based upon non-matching was definitely the way to go.