REGEXMATCH

The REGEXMATCH function tests whether a piece of text matches the regular expression.

Syntax:
REGEXMATCH ( single-text-expression, single-text-expression )
Meaning:
REGEXMATCH ( input_text, regular_expression )
Returns:
A single boolean

Examples

  • REGEXMATCH("abcdXYZ","([a-zA-Z]+)")

    Returns: True

  • REGEXMATCH("ABCDXYZ","([0-9]+)")

    Returns: False