> is there a FoxPro function or does anyone have any code to convert a
> formatted phone number such as (999)999-9999 to its digits only eliminating
> any characters that are not digits?
Well, the quickest way is using function StrFilter from FoxTools:
digits_only=StrFilter(phone_number, "0123456789")
This clears out everything except digits. Using clean Fox only, you'd
have to have a list of unwanted characters to filter them out:
digits_only=ChrTran(phone_number, "()-/+ ","")
This clears out all the characters found in the second parameter.