Validating the Phone Numbers of a Column

Use this function to validate whether the phone numbers in the specified column are valid, whether they are mobile phone numbers, and where they are located.

Procedure
1. From the Phone column menu, click Edit column > Validate phone number.

   

2. In the New columns' prefix field, enter a prefix of column name or accept the default value for the new column.
3. From the Select Vendor list, select one of the phone validators. In this example, select Google libphonenumber(free).
   • Byteplant

     If Byteplant is selected, you must specify the API key in the "Byteplant phone validate configuration" dialog.

   • Google libphonenumber(free)

     Google libphonenumber(free) is the default value.

4. In the Country Code or Country Name field, enter the code or name of the country where the phones numbers are located.
   Note: Either Country Code list or Country Name list is available.

   See https://www.iso.org/obp/ui/#search/code/ for more details about the country names and codes.

   In this example, enter US in the Country Code field.

5. Click OK.
   Three new columns Phone_isValid, Phone_isMobile, and Phone_Location are created.

   

   where:

   • prefix_invalid indicates whether the phone number is valid.
   • prefix_isMobile indicates whether the phone number is mobile phone number.
   • prefix_Location indicates where the phone number is located.