REGEXREPLACE
The following section describes the syntax and usage of the REGEXREPLACE function in ActivityInfo.
Description
The REGEXREPLACE function replaces part of a text string with a different text string using regular expressions.
Syntax
REGEXREPLACE(text, regular_expression, replacement)
Argument | Required | Description |
---|---|---|
text | Yes | The text, a part of which will be replaced. |
regular_expression | Yes | The regular expression. All matching instances in text will be replaced. |
replacement | Yes | The text which will be inserted into the original text. |
Result
- A new STRING with any matching parts replaced.