Phone number regex

[ninedoors]

I have a phone number column in my database that right now has a variety of different combination of formats.  What I would like to do is have the phone number be stored as a 10 digit number, eg. 7058967841 and then I can format it the way I need to when I get it out.  Is there a way to take each string I have and eliminate all characters except the numbers?

 

So if I had (795) 456 - 2345 it would make it 7954562345.  Thanks for the help.

 

Nick

[nrg_alpha]

$phoneNumber = '(795) 456 - 2345';
$phoneNumber = preg_replace('#[^0-9]#', '', $phoneNumber);