[AccessD] Splitting up names

The Split() function will split them into a string array, however, the JR
and two name first names are going to be an issue.  I would create a list of
known suffixes, and then create a suffix field.  Whatever you do is going to
probably require a human to 'review' the results.

Drew

-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Thursday, May 11, 2006 1:22 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Splitting up names

If got a user running a db in Access. She has a list of names and they
were all input into a single "name" field, rather than "last name" &
"first name." She would now like to split these names up, but there are
some double first names, as well as "jr" and "sr" suffixes. 

Is there a way to do this?

Basically names might be like this:

JOHN SMITH JR
MARY ELLEN SMITH
BARBARA SMITH

And I'd need to get them like this into a first name field like:

JOHN
MARY ELLEN
BARBARA

and a last name field like:

SMITH JR
SMITH
SMITH

John W. Clark
Computer Programmer
Niagara County
Central Data Processing

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