Find/Replace characters in Phone field

[jess]

I can't seem to make the find/replace script step appropriately. I want to remove both types of parenthesis and any dashes.

I tried putting the three replaces into a loop, but either fails or it will only do the first script step.

Any suggestions? I have 1.5 million records to clean up and would like remove those special characters in one shibang!

Thanks..

Jess

[Lee Smith]

Use the Filter Function

Filter(PhoneNumberField; "0123456789")

HTH

Lee

[jess]

Uhm..that was way too easy for you Lee.

Thanks for sharing the brain once again.

Jess