REGEX

Syntax

REGEX(<source string>; <regular expression>; <replacement string>[; <string used if the regular expression is not found>])

Description

Using a regular expression, search through a string type column to section the text into groups. Define a replacement string for the result using the index ($) and the sequential group number as a reference. For example, using $1 will be replaced with the first defined group.

Learn more about:

Examples

Source stringRegular expressionReplacement expressionREGEX returns
abc[^b]*(b*)([^b]*)$2$1cb
aaaabbbcs[^b]*(b*)[^b]*- $1--bbb-
s.*(b+).*-$1-null
server.anywhere.com/usr/bin/amavisd(^.*[/\\\\])?([^/\\\\]*)$$2server.anywhere.com/usr/bin
server.anywhere.com/usr/bin/amavisd(^.*[/\\\\])?([^/\\\\]*)$$1amavisd

There is a difference in expressions between the Formula Builder and the Formula Bar.

With the Formula Builder, if you are writing regular expressions, you can use normal syntax. A backslash (\) is used to separate each expression.

With the Formula Bar, if you are writing regular expressions you need to include an extra backslash (\) between each expression. This extra backslash between expressions is due to Datameer X using the backslash as an escape character.

Before using the REGEX function, think about using REPLACEALL or SUBSTITUTEALL for less complex actions. REGEX can be more process intensive and cause a degrade in performance.