MATCHES

Syntax

MATCHES(<string>,<string with regular expression>)

Description

Returns a boolean value (true or false) depending on whether a string matches a regular expression. Datameer tries to match entire record without automatically adding ^ or $ to the regular expression. But if the record has multiple lines, then this must be accounted for with (?s) or line terminators. The each cell must have a value and can't contain a <null> value. Update columns containing <null> values using functions like DENULLIFY or ISNULL.

Examples

nonemptylowercase

.[a-z]*

nonemptylowercase

.[A-Z]*

, 

.[A-Z]*

=MATCHES("nonemptylowercase", ".[a-z]*") returns boolean value true
=MATCHES("nonemptylowercase", ".[A-Z]*") returns boolean value false
=MATCHES("", ".[A-Z]*") returns boolean value false