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!