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

[kavya]

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

--------------------------------------------------------------------------------

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

 

[PHV]

A starting point:
yournumber = Val(Split(yourString)(2))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886