parse a string with years month and days....

[bkalimili]

Solution to parse the strings below and get number of months
1) 10 years 5 months 5 days - Should give 5
2) 6 years 10 months 22 days - Should give 10

 

[EMP]

Try this:-

Val(Mid([TextString], InStr([TextString]," month")-2))

^

 

[PeterF]

Another option would be using the split function like this:

result = split([TextString] , " ")(2)