This step parses, formats and validates international phone numbers.
The Parse Phone Number step implements the Google common library for parsing, formatting, and validating international phone numbers in Data Quality pipelines.
Configure the step properties and output fields on two tabs.
- Step properties Selections on the Step properties tab specify behavior and output of this step.
- Output configuration Selections on the Output configuration tab define the output schema for the Parse Phone Number step.
Step properties
Selections on the Step properties tab specify behavior and output of this step.
Step name
Defines the name for a step. Provide a meaningful name so that anyone who edits steps in a pipeline will be able to identify the purpose of a step.
Default country code
Specifies the default country code. This is required. By default US (United States) is selected.
Country code field
Specifies the field that contains the ISO2 country code (such as US or FR) for each number. This is optional
Phone number field
Specifies the field that contains the phone number.
Output formatted result
Specifies that the output phone number uses E164 or international format.
-
E164 format—Telephone numbers are limited to only digits and to
a maximum of fifteen digits.
+12124567890 +226071234567 +447911123456 -
International format—The + symbol precedes the country code
followed by the city code and the local phone number.
+1-212-456-7890 +22 607 123 4567 +44 7911 123456
Validate Output
Select this checkbox to validate the phone number in its geographic location.
Output configuration
Selections on the Output configuration tab define the output schema for the Parse Phone Number step.
This tab lists output fields defined by the Step properties settings. Clearing the check box next to a field name removes the corresponding field from the Step preview.
All of the fields displayed on this tab are initially selected by default. Clear the check box next to any field that you do not want to include in the step output. Select or clear the All fields check box at the top of the list to select or clear check boxes for all of the fields displayed on this tab.
You typically want to review selections on this tab after you edit settings on the Step properties tab. The fields displayed on this tab change as you configure settings on the Step properties tab. As you change settings on the Step properties tab, the number of selected fields and the total number of fields are displayed in parenthesis on the Output configuration tab label, for example, Output configuration (3 of 6).
Output fields
The following output columns are always added to the dataset.
phonenumberfield
The original phone number the field shows the phone number in the selected output format (E164 or International). The number displays in red text if the input field was in an unrecognized format or the country code is missing in the country code field.
phonenumberfield_PhoneNumberCountryCode
The country code for the phone number.
phonenumberfield_PhoneNumberExtension
The extension associated with the phone number when included (as in 244-555-5555x314 or 244-555-5555 ext. 314).
phonenumberfield_PhoneNumberNationalNumber
The number that is dialed within a country to connect to a phone.
phonenumberfield_PhoneNumberPreferredDomesticCarrierCode
The is carrier code assigned to the corresponding range of national numbers. This is the original carrier for a number. It may not match the current carrier for a number.
Validate Output fields
The following fields are added to the output if the Validate Output checkbox is selected.
phonenumberfield_PhoneNumberType
Shows the type of number when the type can be identified:
- FIXED_LINE
- FIXED_LINE_OR_MOBILE
- MOBILE
- PAGER
- PERSONAL_NUMBER
- PREMIUM_RATE
- SHARED_COST
- TOLL_FREE
- UAN
- UNKNOWN
- VOICEMAIL
- VOIP
phonenumberfield_PhoneNumbertTimeZone
Shows time zone (tz database) identifier in the Region/City format. For example America/Toronto or Asia/Tokyo.
phonenumberfield_PhoneNumberGeoDesc
Geographical information related to a phone number: typically regional or city locations for a phone number
phonenumberfield_IsPossiblePhoneNumber
Evaluates whether a number is a possible phone number by using only the length information. This is faster than a full validation. Values for this field are true or false.
phonenumberfield_PhoneNumber_IsValidPhoneNumber
Full validation validates whether a number is a phone number using length and prefix information. Values for this field are true or false.