REGEX_REPLACE
Returns a new string created by replacing all matches in the specified string using the regex and a replacement string.
Syntax
=REGEX_REPLACE(regex, string, replacement)
Arguments
Argument | Type | Description |
---|---|---|
regex | String | The regex to use when looking for matches |
string | String | The string to look for matches in |
replacement | String | The string to replace all found matches with |
Examples
=REGEX_REPLACE("b.?", "abc", "ZZZ")
→"aZZZ"
Updated 8 months ago