[AccessD] Regular Expressions?

Hi Joe

Perhaps you could apply ProperCase first and then use Replace to change strings like " Lg" with " LG". That depends, but the method is very simple and no normal word begins with LG.
Notice that if 24 and 10 are centimeters resp. millimeters, cm and mm are the correct units, not CM or MM.

/gustav

>>> JRojas at tnco-inc.com 15-03-2006 18:56:26 >>>
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