Match Function

Returns TRUE when a string matches a given pattern. All comparisons are case insensitive.

Syntax

Match( string, "pattern" )

Examples

Match( Product.Reference, "*or*" ) matches or, ord, facilitator, but not asteroid 
Match( Product.DimMemRef, "abc*" ) matches abc, abcd, but not asteroid, a, ab or bc 
Match( Product.Reference, "*xyz" ) matches xyz, wxyz, but not asteroid, x, y, z, or yz 
Match( Product.DimMemRef, "*bil*ion" ) matches billion, abillion, but not billions 
Match( Product.Reference, "???DEF" ) matches abcDEF, ABCDEF, but not DEF, aDEF, abDEF 
Match( Product.DimMemRef, "\*bike\*" ) matches *bike*, *Bike*, but not *bikes* 

Further explanation

Special characters:

*	matches zero or more characters
?	matches any single character
\	used as an escape character to allow matching a literal '*', '?', or '\' in the string. The escape character indicates that the immediately following character in the pattern (*, ?, or \) is being used as itself and not as a special character. For example, Match(Product, Name\?) matches Name? and does not match either Name or Names.

Note: When used in the assignment rule for a rule-based driver, properties are assumed to refer to the destination account unless Source is specified.