I have a database, which is travel related and all names appear in one field "PASSENGENAMEUPPER" in the format ...
KENT/CLARK WILLIAM MR
I can extract the salutation correctly with:
Salutation: Mid([PASSENGERNAMEUPPER],InStrRev([PASSENGERNAMEUPPER]," ")+1)
I can extract the last name correctly with:
But I am stuck with trying to just get the first name and any corresponding second names .. keeping in mnd that some names might have just 1 first name and sime might have multiple. So basically I am looking to extract anything after the slash and before the salutation
Any assistance would be greatly appreciated