Hi all,
I am doing a find/replace to reverse the first initial and last name in a list, like this:
J. Smith --> Smith, J.
I've got that down with:
Find: <([A-Z][! ]@) ([A-Z][! ]@)>
Replace: \2, \1
However, I quickly stumbled across a challenge. Some names have both a first and middle initial, such as
R. M. Johnson --> Johnson, R. M.
Is there a single find/replace query I can run that would account for both types of names (names with just a first initial and names with both first and middle initials)?
Thank you for any ideas you can provide!