[AccessD] Separating First and Last Names

Well it depends on how the input field is formatted. 
 
What if someone does not have a middle name? 
Is it middle name or just middle initial?
Are there suffixes or titles in the name (Sr., Jr., Dr.)
What is done about people with two last names or last names with space in middle De Carlo etc.
 
I have some routines that were set up for this on mainframe - I might have converted them to vba but would have to search for them
 
Could always check Dev Ashish's site for a routine
 
Patti
 
*************************************************************
* Patricia E. O'Connor
* Associate Computer Programmer/Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at dfa.state.ny.us
* (W) mailto:aa1160 at dfa.state.ny.us
***********************************************************

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Coutts, Welford L.
Sent: Mon 04/12/2004 3:48 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Separating First and Last Names



I have received a large file containing a large number of Full Names.
I need to separate the First Name and Middle Initial, if any, into one field
and the Last Name into a separate field.

What is the most efficient way to do this?

Thanks!

Welford Coutts






-----------------------------------------
CONFIDENTIALITY NOTE:  This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information.  If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system.  Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com