The mixmatch function compares the first parameter with all the following ones and returns the number of the expression that matches. The comparison is case insensitive and insensitive to the Japanese Hiragana and Katakana character systems.
Syntax:
mixmatch( str, expr1 [ , expr2,...exprN ])
Tip noteIf you want to use case sensitive comparison, use the match function. If you want to use case insensitive comparison and wildcards, use the wildmatch function.
Examples and results:
| Example | Result |
|---|---|
| mixmatch( M, 'Jan','Feb','Mar') | returns 1 if M = jan |
