[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...;)