<< Prev Question Next Question >>
Question 20/52
A consultant is planning the ingestion of a data stream that has profile information including a mobile phone number.
To ensure that the phone number can be used for future SMS campaigns, they need to confirm the phone number field is in the proper E164 Phone Number format. However, the phone numbers in the file appear to be in varying formats.
What is the most efficient way to guarantee that the various phone number formats are standardized?
To ensure that the phone number can be used for future SMS campaigns, they need to confirm the phone number field is in the proper E164 Phone Number format. However, the phone numbers in the file appear to be in varying formats.
What is the most efficient way to guarantee that the various phone number formats are standardized?
Recent Comments (The most recent comments are at the top.)
The best answer is A
Using a formula field during ingestion automatically cleans up and converts phone numbers into the proper E164 format as the data comes into Salesforce. It’s fast, automated, and doesn’t require fixing the data manually or in the source system.