Parsing phrase from text string

NH0520

Hi,

I'm trying to parse two columns from various text strings, I basically need the first column to have the 5/five and the second to have the year/years from the text strings below (each full string is anywhere from a sentence to a paragraph):

1)

 have 5-year option

2)

of 2, 5 years option

3)

two five-year options

Claje

This regex may be too brittle depending on your actual use case, but it works in this example:

(.*\W)(\w+)\W(years*)(.*)

RegExOut2 and RegExOut3 should be your number and the word year/years.

From there you can probably do some kind of conversion for the word "five".

This makes an assumption that the number of years always precedes the word "year", and that there is always a single non-alphanumeric character between the two.  Depending on the data you are dealing with, you may need to modify this, or cleanse your data into this format in some way.