Hello, Hoping for some assistance.
I need to remove the last 2 characters of a string, only if the 2nd to last character is a space.
Doe, John J
Doe, Jonathan K
Need these to return as
The last character could be any of the 26 letters in the alphabet and the amount of characters before this could be any number.
Essentially, I need to find the last space and if there is only 1 letter following it, remove that space and letter from the string. Any ideas would be appreciated.