CleanUKTelephoneNumber

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