Understanding the Classification Rule Operators
When creating rules, there are two operators that appear to be somewhat similar by name, but behave drastically different. These are the Like and Matches operators.
Like Operator
The Like Operator is used for fuzzy matching against a value by using simple pattern expressions. The most common character used in a Like-based pattern expression is an asterisk which represents a wild card character.
For example, “Property Like *Value*” will match if the property contains the word “Value” anywhere within its value. The full pattern expression syntax is as follows:
Characters in Pattern | Matches in String |
|---|---|
? | Any single character |
* | Zero or more characters |
# | Any single digit (0-9) |
[ charlist ] | Any single character in charlist |
[! charlist ] | Any single character not in charlist |
Matches Operator
The Matches Operator is used for matching against patterns specified by a regular expression.
For example, “Property Matches \b4[0-9]{12}(?:[0-9]{3})?\b” will match if the property contains a credit card number in its value. Regular Expression Language Quick Reference: http://msdn.microsoft.com/en-us/library/az24scfc(v=vs.110).aspx