Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 X 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 terminatorsThe each Each cell must have a value and can't contain a <null> value. Update columns containing <null> values using functions like DENULLIFY or ISNULL.

...