Selecting only the numbers

[Lorien2733]

I am trying to use a very sloppy telephone list. My table is set up
(aaa)nnn-nnnn but the list I'm trying to use is horrible. Some entries have
area codes, some don't. Some have extensions some don't. Some are missing the
area codes but have the empty parentheses. Some have dashes, some don't. Some
have garbage characters. It's a mess but it's all I've got. Is there some way
that I can pull out just the numbers in the field? That at least will get me
something I can work with.

TIA,
Lynne

 

[Graham R Seach]

Lorien,

Try this:
http://www.pacificdb.com.au/MVP/Code/StripChars.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia