REGEXMATCH

The following section describes the syntax and usage of the REGEXMATCH function in ActivityInfo.

Description

The REGEXMATCH function is used to test whether a string (or text value) matches a regular expression.

Syntax

REGEXMATCH(text, regular_expression)

Argument Required Description
text Yes The text to be tested against the regular expression.
regular_expression Yes The regular expression to test the text against.

Result

  • TRUE if the text matches the given regular expression
  • FALSE if the text does not match the given regular expression
  • BLANK if the regular expression is invalid