Clean Inconsistently Formatted Phone Numbers
Easy
string-functions
Twilio
Salesforce
HubSpot
Given a contacts table with a phone_raw column containing phone numbers in inconsistent formats (with parentheses, dashes, dots, or spaces), write a query that strips all formatting characters down to just the 10 digits.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...