Product: Omatic Cloud

Description: This solution discusses what the Telephone format Clean up can do for your data

Environment: All

Versions: All

Answer:


Depending on the source of your data, phone numbers may appear in a variety of formats.  Allowing Omatic Cloud to make them consistent will lead to cleaner data in your destination.  More importantly, varied formatting can affect the quality of phone-based record matches.  


Clean up options are found by going to the field mapping screen and clicking on the gear icon to the right of your mapping. 


Select Clean up, and a new screen will appear with the different clean up options available. Below we will walk through the Telephone format options:


Telephone format provides 3 options:

  1. None - this leaves the phone numbers as-is, to maintain the format provided by your data source.
  2. Remove Formatting  - this replaces the Numbers Only functionality and will strip out any special characters from a telephone number.
  3. Remove Formatting & Country Code 1 - this will strip out any special characters from a telephone number, and if the remaining value is 11 digits and the first digit is "1", this will also remove the "1".


In our example record, you can see that this is a fully formatted telephone number including special characters and country code "1":


We are going to explore the other two options we have for Telephone format.


Here is an example that shows the Telephone format: Remove Formatting clean up after it has been applied to the Home Phone field. This clean up has removed all special characters from the phone number:



Here is an example that shows the Telephone format: Remove Formatting & Country Code 1 clean up after it has been applied to the Home Phone field. This clean up has removed all special characters and the "1" country code from the phone number:


For now, Omatic Cloud will only remove Country Code 1, as it covers the majority of phone numbers currently being moved through Omatic Cloud.  For more information on which countries are included, please review this article about the North American Numbering Plan.  To request additional Country Codes be added, please click here to post in our Ideas forum.