Creating the same number format in a field

[#1]

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??

[biester]

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

Rgds,
Joachim

[#3]

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]

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

Rgds,
Joachim

[#5]

worked perfectly, thanks alot...