RE: [AccessDevelopers] phone number conversion

[Jose Luis Mora Jr]

The only way that I could think of accomplishing this is by using the following functions: InStr() – this function will find the first occurrence of a dash starting from the left side in your account number and return a number where the dash is located. InStrRev – this will perform a similar function as InStr but will find the first occurrence of a dash starting from the right side of the account number. Left() – this function will take the first x characters starting from the left of the account number. Right() - this function will take the first x characters starting from the right side of the account number. Mid() -  this function will take a set of characters and somewhere in the middle of the account number starting at a position you need and then take the following x character from that location.   You can see what these function do in more detail from the help files. Hope this helps.   Jose       "When you come to a fork in the road, take it." - Yogi Berra   -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of teresaamc Sent: Wednesday, October 12, 2005 12:28 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] phone number conversion   I've got a list of account numbers that appear to be formatted with dashes and spaces between the numbers. I need to convert these numbers to a format without spaces or dashes. I've tried searching the messages here and can't come up with any results. Does anyone have a solution for me? Thanks!!! Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.