[AccessD] Regular Expressions?

Joe,

Not sure what you'd be using RegEx for?  AFAIK they won't format your
data just find items that match a pattern.

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: Wednesday, March 15, 2006 12:56 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Regular Expressions?

How can I add the ability to use regular expression in Access 2000?

**Background**
We are performing data conversion from our old MRP system to our new ERP
system and we are using Access to massage the data in between the two
systems.
One of the decisions that we made was to go from all capital letters in
our part number descriptions to proper case. At first I thought I would
just convert each word to proper case but then I noticed that some of
our descriptions look like "24CM 10MM ADAPTOR SLEEVE LG" and we would
like the resulting text to look like "24CM 10MM Adaptor Sleeve LG" not
"24cm Adaptor Sleeve Lg".
My best guess is to use regular expressions to identify most patterns
and then probably go over the data manual to make sure we didn't miss
anything.

Anyone have a better idea?

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************