Transforming the Phone Number Format of a Column

Use this function to change the representation of phone numbers.

Take project 1 in the Sample-customer dataset as an example. The phone values in the Phone column is in the 999-999-9999 format, you have to change this format to the (999)999-9999 format.

Procedure

  1. From the Phone column menu, click Edit column > Transform phone number.
  2. In the New column name field, enter a name for the new column.
  3. Select one of the following error handling options. In this example, select the first option.
    • Set to blank
    • Store error
    • Copy value from original column
  4. From the Country list, select the code of the country where the phone numbers are located. In this example, select US.
  5. In the Regular express field, specify the pattern of phone number or accept the default expression.
  6. From the To format list, select the desired target format. In this example, select (999)999-9999. Click OK.
    A new column Copy_Phone is created, and all the phone numbers are in the (999)999-9999 format.