Remove formatting from phone nos in Contact data

[Guest]

Is there any way to remove formatting symbols like parentheses, forward
slashes and dashes from contact phone and fax nos? I believe this would be
best done by query. Are there any knowledge base articles on this subject?
This seem like it would be a common question.

 

[MGFoster]

Is there any way to remove formatting symbols like parentheses, forward
slashes and dashes from contact phone and fax nos? I believe this would be
best done by query. Are there any knowledge base articles on this subject?
This seem like it would be a common question.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can use the Replace() function (Access 2000 and higher).

Replace(Replace(Replace(phone_nbr,")",""),"-",""),"/","")

In an Update query, in the Query grid, place the above in the Update To
cell of the Phone number's column. Change the phone_nbr to whatever
your column name really is.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRVKnC4echKqOuFEgEQJ3vACgoqygaXBKeS5FcyuPdMTa6f3FhvcAoMpE
CKRvB/9nJScDhW5HRnzhdRVA
=D1Eu
-----END PGP SIGNATURE-----

 

[Guest]

Thanks for your reply. One question before I try this. What goes in the
criteria row? My experience is that I will be prompted for something to go
in the Criteria row.