Reversing a Name in field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TotallyConfused - 26 Mar 2008 14:25 GMT

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.

Reply to this Message

Jerry Whittle - 26 Mar 2008 17:08 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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.

Reply to this Message