Replace Values — Solution & ExplanationProblems / Replace Values / EditorialApproachPhone cleaningUse REGEXP_REPLACE(phone, '[^0-9]', '', 'g') to strip everything that isn't a digit. The [^0-9] pattern matches any non-digit character, and the 'g' flag ensures all matches are replaced (not just the first).Alternatively, you could nest multiple REPLACE() calls, but regex is far cleaner.Email cleaningA simple REPLACE(email, 'mailto:', '') suffices since the prefix is a fixed string.PySparkF.regexp_replace() replaces all occurrences by default (no 'g' flag needed).Hints

REPLACE(string, from, to) handles simple literal substitution.

For removing all non-digit characters, REGEXP_REPLACE with pattern '[^0-9]' is more concise than nested REPLACE calls.

In DuckDB, REGEXP_REPLACE needs the 'g' flag to replace ALL matches, not just the first.

Solve Replace Values yourself →