I'm creating a report in Crystal and I would like to change the telephone number so that the 0 at the front of the number is removed, plus any non number characters are removed, i.e (, *, etc.
The format i've got at the moment is random:
01234 358824
0171-254-2545
I would like it so that the numbers above could be changed to:
1234358824
1712542545
Is this possible?
The format i've got at the moment is random:
01234 358824
0171-254-2545
I would like it so that the numbers above could be changed to:
1234358824
1712542545
Is this possible?