>I have 8,000 records in a table. I would like to remove any characters such as(,),- that are currently there separating the area code from the number, being left with just the numbers.
>Example:
>Current: (800)555-5555
>I would like to see: 8885555555
>Then I can set the format and input mask properties for future entries.
Just to prove that anything can be done at least three ways in Fox, else it's not worth doing:
If you're using FoxTools.fll, you have the strfilter function:
Replace all cPhone with strfilter(cPhone, "0123456789")