FORMAT_PHONE_NUMBER
Returns a column in which a phone number string is converted into a formatted value.
Parameters
-
sourceColumn– The name of an existing column. -
phoneNumberFormat– The format to convert the phone number to. If no format is specified, the default isE.164, an internationally-recognized standard phone number format. Valid values include the following:E164(omit the period afterE)
-
defaultRegion– A valid region code consisting of two or three uppercase letters that specifies the region for the phone number when no country code is present in the number itself. At most, one ofdefaultRegionordefaultRegionColumncan be provided. -
defaultRegionColumn– The name of a column of the advanced data typeCountry. The region code from the specified column is used to determine the country code for the phone number when no country code is present in the number itself. At most, one ofdefaultRegionordefaultRegionColumncan be provided.
Notes
Inputs that can't be formatted to a valid phone number remain unmodified.
If no default region is provided, and a phone number doesn't start with a plus symbol (+) and country calling code, the phone number isn't formatted.
Example: Fixed default region
{
"Action": {
"Operation": "FORMAT_PHONE_NUMBER",
"Parameters": {
"sourceColumn": "Phone Number",
"defaultRegion": "US"
}
}
}
Example: Default region column option
{
"Action": {
"Operation": "FORMAT_PHONE_NUMBER",
"Parameters": {
"sourceColumn": "Phone Number",
"defaultRegionColumn": "Country Code"
}
}
}
