Regular Expressions

To leverage the power of the regular expression syntax, a MATCH function was added. This function takes two parameters where the first is a regular expression string and the second is the string to be operated on. The return value is a boolean that reflects whether the source string (second parameter) matched the regular expression (first parameter). Uses C# Regex.Match, "System.Text.RegularExpressions".

Examples

MATCH('^\d{9}$','123456789')    // Must be exactly nine digits in the source string provided, return value of "true"
MATCH('^\d{9}$','0123456789')   // Must be exactly nine digits in the source string provided, return value of "false"