REGEXREPLACEALL
The REGEXREPLACEALL function replaces all occurrences of the regular expression with the replacement text in the input text.
- Syntax:
- REGEXREPLACEALL ( single-text-expression, single-text-expression, single-text-expression )
- Meaning:
- REGEXREPLACEALL ( input_text, regular_expression, replacement_text )
- Returns:
- A single text item
Examples
REGEXREPLACEALL("ABC 7 DEF 8 GHI", "\d+", "###")Returns: ABC ### DEF ### GHI
REGEXREPLACEALL("10 1 1 1", " ", ".")Returns: 10.1.1.1