When phone numbers were imported into our ebase the area code and telephone number were all put in the same field (HOME PHONE NUMBER etc). I'm in the process of cleaning up the fields and would like to know if there is an easy way to delete the area codes from the telephone number string for a found set. For example for numbers entred "604 430-4332", i would like to delete the "604_" and have "430-4332" remain. Likewise, number entered (604) 430-4332, i'd like to delete the "(604)_".
thanks. shaugn ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
