Link to home
Start Free TrialLog in
Avatar of howruaz9
howruaz9Flag for Canada

asked on

Phone # to number

Hi experts,

I have a phone# field formatting like (111) 123-4567, now I'm asked to provide number without area code and Hyphen, that means I should get 1234567. How do I get it?

Thank you very much in advance!
SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of howruaz9

ASKER

Hi MX & cap,

Thank you very much to both of you, both solutions are working perfectly well.

All the best,
@DatabaseMX

That pattern looks so familiar  ; )
Yep ... thanks to you. And I had a comment crediting you. But I see what happened.  I have the code in two different places and grabbed the slightly older version ...
Heheheh...   Can't beat code reuse!
Thanks to you too, kaufmed. It's nice that the code is so popular and helping many people like me.
Couple of my old friends like MX (if you don't mind to be called old friend, MX) that have been paying attention to my questions for many years are always acting quick, I appreciate their effort.

Thanks all again!
no problem.  kaufmed must have a filter set for 'phone number', lol