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