Skip to main content

Documentation Index

Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

Description

Normalizes a phone number string to E.164 format (a leading +, country code, and subscriber number with no spaces or punctuation). Use it to standardize phone values from mixed sources before storing, deduplicating, or joining on phone.

Syntax

NormalizePhone(string_expression)

Examples

NormalizePhone('+1 (415) 555-2671') returns '+14155552671'. NormalizePhone('415-555-2671') returns '+14155552671'. NormalizePhone('+44 20 7946 0958') returns '+442079460958'.

Return value datatype

String

Impact of null value

If input is null, returns null. If the input cannot be parsed as a valid phone number, returns null.
Last modified on May 26, 2026