REGEX_TEST

Returns true if the specified string is matched by the supplied regex.

Syntax

=REGEX_TEST(regex, string)

Arguments

ArgumentTypeDescription
regexStringThe regex to use when looking for matches
stringStringThe string to look for matches in

Examples

=REGEX_TEST("b.?", "abc")true

=REGEX_TEST("x+", "abc")false