REGEXREPLACE

Description

The REGEXREPLACE function replaces part of a text value that matches a regular with expression with new text.

Usage

REGEXREPLACE(text, regular_expression, replacement)

Arguments

Argument Type Required Description
text Text Yes The text, a part of which will be replaced
regular_expression Text Yes The regular expression. All matching instances in text will be replaced
replacement Text Yes The text which will be inserted into the original text

Result

  • A new STRING with any matching parts replaced.

Examples

The REGEXREPLACE can be useful in cleaning collected data. For example, if you had previously collected numeric value in an open text field with code FAMILY_COUNT, and some of your staff used the period as the thousands seperator (e.g. "4.000" and "3.500") and wanted to convert the values to numbers using the VALUE.

VALUE(REGEXREPLACE(FAMILY_COUNT, ",", "."))
Next item
GREATER (>)