[AccessD] Splitting up names

How many records are there?

I had a system that I needed to split addresses.  Sometimes they even had an
institution with them so I had to account for that as well.

I had someone here do it somewhat manually.  I created a form that showed
the full text and had a field for every resulting piece.  They would enter
the complete text, insert a $ where the split should be, hit tab, and the
data was split accordingly and the proper pieces went to the appropriate
field.  Then focus was set to the second field and the same thing happened.

This allowed the splits to happen very quickly while also being confirmed by
a person.

I could have also had the user just enter my chosen delimiter ($) several
times in one string and split it all in one step.

The person that did this fixed about 2,000 address in 5-6 hours.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark
> Sent: Thursday, May 11, 2006 2: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
>