Skip to main content

wildmatch - script and chart function

ON THIS PAGE

wildmatch - script and chart function

The wildmatch function compares the first parameter with all the following ones and returns the number of expression that matches. It permits the use of wildcard characters ( * and ?) in the comparison strings. The comparison is case insensitive.

Syntax:  

wildmatch( str, expr1 [ , expr2,...exprN ])

 

Tip: If you want to use comparison without wildcards, use the match or mixmatch functions. match has the best performance of the 3 functions.

Examples and results:  

Examples and results
Example Result
wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex