REGEXREPLACE

The REGEXREPLACE function replaces the first occurrence of the regular expression with the replacement text in the input text.

Syntax:
REGEXREPLACE ( single-text-expression, single-text-expression, single-text-expression )
Meaning:
REGEXREPLACE ( input_text, regular_expression, replacement_text )
Returns:
A single text item

Examples

  • REGEXREPLACE("ABC 7 DEF 8 GHI", "\d+", "###")

    Returns: ABC ### DEF 8 GHI

  • REGEXREPLACE("ABC_DEF_GHI", "_", " ")

    Returns: ABC DEF_GHI