Separating last and first names

[scra]

I have a field with last, first names, title. I would like to place them into 4 separate fields as:

name
SMITH, JOHN R MD

last name
SMITH

first name
JOHN

middle init
R

title
MD

Please advice. Thanks.

 

[THoey]

Please see the FAQ section or do a search. The answer to this has been posted many times... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...