Regex help to parse out data with a set pattern

I have a data set that has a column with junk data surrounding the data I need.

Example: RS345, WIhihdh, 19-999878 or

D124, 18-878789 RT2A

I need to keep only the 19-000989 or the 18-878789. I need to create a string expression that will look for xx-xxxxxx and create a new column for this data.

I'm trying to use the multi-row formula tool I'm struggling with the string expression. Any advice would be appreciated.

Regex

Parse

Preparation

Accepted answers

Blake

Hi @heatherreid70

Try this and let me know if it works for you.

regexsample.yxmd

All comments

Blake

Hi @heatherreid70

Try this and let me know if it works for you.

regexsample.yxmd

heatherreid70

this works like a charm! thank you so much

AshleenKenney

Hi Blake,

Thank you for your solution I found it very helpful as well. However, in my case the field may contain the same pattern .*(\d{2}-\d{6}).* more than once and I would like every instance of the pattern parsed/returned. How would I change the expression to account for multiple instances?

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703