On 10/25/06, Mark <[EMAIL PROTECTED]> wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such a
Mark wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database
by different people so there was no consistency in the format used.
There are now names entered such as:
Smith, John S.
Doe - Jane
I don't have any suggestions for a script, but I've wrestled with this issue
before in other places. It is very difficult to regularize the format of a
full name:
Johnson, Jr. - Fred
Applewhite-Smith, Pamela
Quimby III, Roger Alan
etc. I suppose it all depends upon how bad the existing data is, a
