Exam Certified Data Cloud Consultant topic 1 question 87 discussion

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?