Splitting a phone number

Last Updated : Jun 27, 2018 |

About this task

Use this procedure to split a phone number in your Customer Data table if the international code or area code is combined with the telephone number in the imported data. You must ensure that the phone number in the Customer Data table is valid by removing a specified number of digits from the beginning of the Phone Number and adding those digits to the selected Intl or Area Code column.

Before you begin

Ensure that you have data in the Customer Data table.

Procedure

  1. On the Oceana Customer Management Tool interface, click Import customer data.
  2. Click Customer Data Cleanup.
  3. Click the Split Phone Number tab.
  4. In the Split Field into field, click one of the following:

    • Intl Code

    • Area Code

  5. In Number of digits to split, enter the number of digits to remove from the Phone Number and add to the selected Code column.
  6. Do one of the following:

    • To split the phone number in all rows of the table, click All Customers.

    • To split the phone number in only selected rows of the table, select the specific rows, and then click Selected Customers.

  7. Click Split Phone Number.
  8. Click Continue .
  9. Click OK.