REGEXP_REPLACE
Replaces substrings matching a regular expression pattern with a replacement string.
Analyze Syntax
func.regexp_replace(<str>, <pattern>, <replacement>)
Analyze Examples
func.regexp_replace('hello world', '\\s+', ' ')
┌───────────────┐
│ 'hello world' │
└───────────────┘
SQL Syntax
REGEXP_REPLACE(<str>, <pattern>, <replacement>)
SQL Examples
SELECT REGEXP_REPLACE('hello world', '\\s+', ' ');
┌─────────────┐
│ hello world │
└─────────────┘