how to reformat phone number?

[susan88]

Does anyone know of a script that will examine and modify phone numbers to use numeric only?

I have migrate mbv4 to whmcs using built in import script, the phone number is not uniform like +AA-BBB-CCCCCCC, +AA-BBBCCCCCCC, +AA.BBBCCCCCCC, BBB-CCCCCCC, etc

[b.ahmed]

Don't know how to do this but you could edit the viewcart.tpl and add instruction at the bottom of phone number field.

[Kiwispy]

Same problem here. I need to have a phone number like this :

 

+1.123456789

 

All my registration fail without this phone number format...

[laszlof]

If you want to make sure they're all uniform going into WHMCS, you could do it with jquery masked input plugin.

 

<script src="http://jquery-joshbush.googlecode.com/files/jquery.maskedinput-1.2.2.js" type="text/javascript"></script>

<script language="javascript">
jQuery(function($){
 $("#phone").mask("(999) 999-9999");
});

 

Then just set the id tag on the text box to "phone"

 

<input type="text" id="phone" name="phone" size="25" />
[code]
 
This is completely untested. More information on usage can be found here:
 
http://digitalbush.com/projects/masked-input-plugin/
 
For already existing data in the database.. You might want to look at this:
 
http://stackoverflow.com/questions/52315/t-sql-trim-nbsp-and-other-non-alphanumeric-characters