[AccessD] Remove Punctuation

...bureaucrats! ...this game gets really out of hand when you start putting
in names like Dong Wong Song Jong, etc. ...the only real answer is to parse
the name into separate fields and concatenate all subsequent versions on
demand ...otherwise you inevitably get data entry errors and dupes :(

William Hindman
<http://www.freestateproject.org> - Next Year In The Free State!


----- Original Message ----- 
From: "Greg Smith" <weeden1949 at hotmail.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, January 22, 2004 6:05 PM
Subject: Re: [AccessD] Remove Punctuation


> Perry:
>
> That's a good question.  One that the State Recorder's are still wrestling
> with since they came up with this stroke of brilliance.  If we leave the
> 'history' data alone, they'll have to do a 'double search' to make sure
they
> get every occurance of, say, "Smith, Greg W." if all the current history
> stays as it is, and everything after Feb 1 is changed to no punctuation.
> They are apparently striving for consistancy in the data, but by doing
this,
> they are causing inconsistancy to say the least.  And each individual
> recorder's office can choose to either change the history or not.  Gives
me
> a headache just to think about what the result of this is.
>
> But, we'll play if they pay.  Right now they are leaning toward NOT
changing
> the history.  Sigh.
>
> Methinks it's time for a brewsky...after I get home.  Or more.
>
> Greg
>
>
> ----- Original Message ----- 
> From: "Perry Harold" <pharold at proftesting.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Thursday, January 22, 2004 2:36 PM
> Subject: RE: [AccessD] Remove Punctuation
>
>
> As an aside - If you ever need to identify the last name again (assuming
> that the field is a Full Name field from your example), how will you find
> any multiple-name last names that don't include dashes?
>
> Perry Harold
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Greg Smith
> Sent: Thursday, January 22, 2004 11:57 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Remove Punctuation
>
>
> Hello everyone!  Greetings from Frigid Iowa.
>
> Access 97.
>
> I need to remove punctuation from a single field in a table which has
about
> 1,500,000 records in it...so far.  It's only 4 columns wide, but fairly
> lengthy.
>
> blah blah blah...;)
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>