Joe Rojas
JRojas at tnco-inc.com
Wed Mar 15 12:43:20 CST 2006
Good point. I should have included the rest of my logic. I plan on checking to see if each word matches a particular pattern and if it does then I would NOT convert to proper case else I would convert. Thanks, Joe Rojas IT Manager TNCO, Inc. 781-447-6661 x7506 jrojas at tnco-inc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim DeMarco Sent: Wednesday, March 15, 2006 1:14 PM To: Access Developers discussion and problem solving Subject: Re: [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". *********************************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com