REGEXREPLACE Function
This article will explain the REGEXREPLACE function
You can reference all available macros in this article: Windward Functions Reference.
Overview
The REGEXREPLACE function replaces part of a text string with a different text string using regular expression.
For example:
=REGEXREPLACE("Google Doc 101", "[0-9]+", "777") returns "Google Doc 777"
Syntax
=REGEXREPLACE(text, regular_expression, replacement)
- text - Required. The text to be tested against the regular expression
- regular_expression - Required. The regular expression to test the text against.
- replacement - Requested - The text which will be inserted into the original text.
0 Comments
Add your comment