Email and Telephone Validation: Phone Number Standardization
Phone number standardization can format phone numbers on your rows to improve your data quality, making it easier to analyse your data.
Phone Number Standardization Setup
From the “Phone Validation” configuration page in the “Data8 Validation Configuration” model driven app, there is an option to enable phone number standardization.
Enabling this will expose some options to customize how to format the phone number.
More information on each of these options:
Default Format Type
The format of the returned phone number. This can be one of the following values:
International– the number is presented back with full international dialling codeNational– the number is presented back without the international dialling code but with the full area codeLocal– the number is presented back with only the local part
Different Format Countries
Any telephone numbers for these countries will be formatted using the DifferentFormatType format instead of the DefaultFormatType. If this is not specified it will default to the same value as the defaultCountry parameter. To format all telephone numbers according to the DefaultFormatType regardless of country, do not select any countries. If a country does not exist in the list of options, a new country can be added by typing the country code (without leading + or 00) and clicking “Add”.
Different Format Type
The format the telephone number should be returned in if it is from a country listed in DifferentFormatCountries. This can be one of the same set of values as DefaultFormatType.
Custom Format Countries
The TelephoneNumber field in the result will be formatted according to our standard country-specific rules. This option allows you to override those formats. Custom formats are specified as a semi-colon separated list of <countrycode>=<format>, where <countrycode> is the international dialling code and <format> is the format to use for telephone numbers in that country.
Formats are specified using the following special characters. Examples show the result of the formatting character based on the input telephone number +441513554555 extension 1234.
| Character | Description | Example |
|---|---|---|
0 | The next available digit of the telephone number. This will not include the international dialling code for the country, or the trunk dialling prefix | 1 |
i | The international dialling code for the country | 44 |
t | The trunk dialling prefix required for long distance calls within the country. | 0 |
a | The area code of the telepone number. This will not include the trunk dialling prefix | 151 |
l | The local part of the telephone number | 3554555 |
x | The extension number | 1234 |
Any other characters will be treated as literal strings. The backslash character is used as an escape character, so \i will output i and \\ will output \.
If there are more numbers in the telephone number than are output by the specified format string, the additional numbers will be appended to the result to ensure no data is lost.
Use Local Formatting
Indicates if telephone numbers should be formatted according to the country-specific rules for its particular country with spaces, punctuation etc. If this is set to false, numbers are formatted according to ITU international standard formatting.