TEXT
regexmatchexact
PATTERN

The regexmatchexact operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).


Parameters

This operator has two parameters:

text – The text you want to match.

pattern – The regular expression.


Description

This operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions). The regexmatch operator is case sensitive (it recognizes the difference between upper and lower case letters) – if you want a case insensitive match use the regexmatch operator.

Entire books have been written about regular expressions (see Regular Expressions for recommendations), and you’ll probably want to read one or more of these books to get the maximum benefit from this powerful tool. Here are some very simple examples.

Does text contain a number?

     "Deadline is in 34 days" regexmatchexact "[0-9]+" ☞ TRUE
      "Deadline is Friday" regexmatchexact "[0-9]+" ☞ FALSE

Does text contain any upper case letters?

      "Bob Smith" regexmatchexact "[A-Z]" ☞ TRUE
      "mary wilson" regexmatchexact "[A-Z]" ☞ FALSE

Is the text a valid upper case e-mail address (valid format, at least)? (Of course e-mail addresses can usually contain lower case characters, but for the purpose of this example we’re assuming only upper case letters are valid.)

      "JOE@BOB.COM" regexmatchexact "^[A-Z0-9!#$%&'*+/=?`{|}~^.-]+@[A-Z0-9.-]+$" ☞ TRUE
      "joe@bob.com" regexmatchexact "^[A-Z0-9!#$%&'*+/=?`{|}~^.-]+@[A-Z0-9.-]+$" ☞ FALSE

The final example gives you a taste of what Regular Expressions are capable of.


Error Messages

RegexMatchExact operands cannot be numeric. – You’ll see this message if either of the operands contains a numeric value.


See Also


History

VersionStatusNotes
10.0NewRegular expression support is new in this version