find and replace trouble - need urgent response please!

[Guest]

I need to search a phone number field and replace a normal phone number i.e. (999)999-9999 with just the numbers i.e. 9999999999. I need to do this using the find and replace in datasheet view of a table. I would really appreciate any help I can get with this ASAP... I know what to put in the find box, my trouble is what to put in the replace field

Thank you soooooo much for any help!!!
Ruby

 

[Greg Kraushaar]

Ruby, hit the carriage return occasionally when you post
Your message scrolls right off my screen.
Not every browser supports auto wrap, or has it turned on.

Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)

 

[John Spencer (MVP)]

The only way I know to do this using the find and replace dialog is in steps.

Find: (
Replace with: Leave it blank

Repeat this for -, ), and space

If you want to do this using a function and an sql query you can do that.