Hi Folks, I need to clean up some data and didn't realize just how dirty the data was. I'm new to REGEX so I'm having difficulty with the multiple variations I'm seeing, any help is appreciated.
Here's a sample:
Data From Source Desired Output
25014078FULLMATURITY FULLMATURITY
V27192526 SURRENDER SURRENDER
FULL SURRENDER FULL SURRENDER
2402337 MATURITY MATURITY
2429316 MATURITY MATURITY
2430792 P.MATURITY P.MATURITY
Solved! Go to Solution.
Here's an example of one way to do this:
This regex will look for anything after a number. I made it an optional unmarked group to account for the third record. Let me know if this would work.
(?:.*\d)?(.*)
@Luke_C Thank you - this worked perfectly. The number of variations threw me for a loop. Someday the REGEX will not be such a challenge.