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 10 months ago