Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating the same number format in a field

Hi everyone

Please help, i've got a field with all cell fone numbers which i'm bringing in from an excel sheet, but they are some have different formats eg. one number will be formatted: 0117836431 (which is the format i want) and others would be formatted: 011-2345765, 011 365 2365, 011543 7896 etc. In the script, how do i make them all the same format??

13 Replies
biester
Specialist
Specialist

PurgeChar takes 2 parameters; you need every character only once in the second parameter. Enclosed find an example.

Rgds,
Joachim

Not applicable
Author

The thing is there are not only dashes in the wrong format, there are also commas, spaces and brackets which i need to get rid of...

biester
Specialist
Specialist

Have you looked at my example? Put spaces, commas,brackets,semicolons, whatever you want to 'delete' into the 2nd parameter.

Rgds,
Joachim

Not applicable
Author

worked perfectly, thanks alot...