Hi - I have an example of a string below
17062017 7.89 11-13-20 DOE JANE A 17062108 7.63 11-13-20 DOE JOHN B
This comes from a pdf with two columns of data. I need to get all numerical data before the names. Names are not always the same length but have a space before and after. Dates do not always end in 20 - could be 19 or 21, or moving forward 22. The first set of numbers - transaction ID is currently 8 characters but can expand moving forward and not all of the transaction IDs start with “1”. The dates, however, will allways be /XX for the year. I have tried splitting the string but am having disjointed luck. Working through regex but having similar difficulty…ideas?