[AccessD] Splitting up names

http://www.helenfeddema.com/access.htm
Parsing Name and Address Data -- The Utilities 	accarch83.zip 
<Files/accarch83.zip>

This might be helpful. There are companies that do address cleaning for 
$0.05 to $0.10 each

DWUTKA at marlow.com wrote:

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

-- 
Marty Connelly
Victoria, B.C.
Canada