Hi Henry,

There were few threads recently on the same topic. Anyway, you need CHRTRAN function, e.g.

phone = chrtran(OldPhone,"()- ","")

or

lcDigits = "1234567890"
phone = chrtran(OldPhone,chrtran(OldPhone, m.lcDigits,""),"")

>Hi all:
>
>I currently have an Excel spreadsheet with data from an MDB file, which I plan to insert into a new VFP free table.
>
>

USE Details
>ZAP
>APPEND FROM c:\Delta\Clients TYPE xls

>
>The above code works. I proceed to select information from Details.dbf into a cursor and then assign some variables their values from the fields in the cursor.
>
>Problem: There is one field which contains the phone numbers along with their area codes, formatting and sometimes it even contains text e.g.
>
>

MESS:(999) 999-9999

>
>How do I parse the numbers only i.e. only the 9999999999, so that I can assign this vlaue to a variable which will then be inserted into the main client table.
>
>Thank you for your guidance.