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

E-Mail me when someone replies to this comment