String Manipulation (Regex)

Problem

Users have been inputting their phone numbers in a dozen different formats (e.g. 555-1234, (555) 1234, 555.1234). You need to clean this up before pushing to the data warehouse. Write a query that outputs concept with the value: "Data engineers use regex functions like REGEXP_REPLACE to cleanse and extract messy text data."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution