Description
Replaces non-numeric characters commonly found in telephone numbers (space, hyphen, “(” and “)” and adds a leading zero where necessary.
Syntax
CLEANUKTELEPHONENUMBER(<input>)
Arguments
| Argument | Type | Description | Optional |
|---|---|---|---|
| input | Text | The text/telephone number to clean. | No |
Returns
Text
Examples
| Expression: | CLEANUKTELEPHONENUMBER("1234-5 67-8910") |
| Returns: | 012345678910 |