hi A MAN,
Have you tinkered with PDF Options before loading the PDF? The PDF Options like stretch, monospace helps aligning columns and changing spacing for easier templating.
For your PDF, if you can just add a space before name and number then it would be easier to split those two using RSplit function or other string functions.
I'm away from my PC today, so can't work out the exact formula. But I think the following approach would work.
First, use the Rsplit based on the - character.
Strip all spaces.
Then test the 2nd character using Isalpha.
If it is, you know the - is in a name, so strip all non numeric characters.
If it is not, then it should be the final result.
I think the initial rsplit on - will give you an empty field if there is no -, so you may need to test that first using instr.
This works in my mind! But I need to test it to be sure and come up with a calculated field.
Get Outlook for iOS<https://aka.ms/o0ukef>