Looking to see if there is a decently easy way to turn a character data point similar to 8 year(s), 6 month(s) and 5 day(s) into a number value like 8.52 (or whatever the calculation is). I am trying to obtain the start date so the transformation is not needed, however, wanting a backup in case I cannot obtain it.
Ideally, want to have the result be something like 8.52 which reflects 8 eights, 6 months and some days. At a loss how to do this.