Reversing a Name in field

[TotallyConfused]

How do I reverse a name in a field? I have a column with names that are in
this order: Last, First Mid degree = Clooney, George J., MD change it to
read George J. Clooney, MD. However, if there is no MD, I do not want the
name to change.

Any help will be greatly appreciated Thank you.

 

[Jerry Whittle]

You do it manually. Seriously. You already brought up one problem with
automating with the MD suffix. How about these:

van der Mark, George J., MD

van der Mark III, George J., MD

Mark, George

Day, Mary Alice, RN BSN

Sting

Then add in that the data is probably not perfectly "clean" in the first
place.

Now if you are getting this data from another system, such as an exported
CSV or text file, go to the source and see what they can do for you. They may
well be able to export the data in FirstName, LastName, MI, Suffix fields.