REGEX_REPLACE
The REGEX_REPLACE function searches the text for matches to a regular expression pattern and replaces each match with specified new text.
Use
REGEX_REPLACE( old_text, pattern, new_text )
Replaces characters within the text matching the specified regular expression pattern with new text.
Parameter | Required | Description |
---|---|---|
old_text | Yes | text in which to replace some characters |
pattern | Yes | the regular expression to match |
new_text | Yes | the text that will replace characters in old_text (supports capture groups) |
Returns | Text |
Example
This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.