FORMULA LANGUAGE


@Matches
Example

Tests a string for a pattern string. Because the pattern string can contain a number of "wildcard" characters and logical symbols, you can test for complex character patterns.

Syntax

@Matches( string ; pattern )

Parameters

string


pattern
Return value

flag

The wildcard characters and symbols are as follows:
SymbolUse
CWhere C is any character. Matches any single, non-special character C (or c)
?Matches any single character
*Matches any string (any number of characters)
{ABC}Matches any character in set ABC
{A-FL-R}Matches any character in the sets A...F and L...R
+CMatches any number of occurrences of C (or c)
!Complements logical meaning of the pattern (logical NOT)
|Performs logical OR of two patterns
&Performs logical AND of two patterns
Note When specifying sets, be sure to enclose them in { } (curly braces). For example, the set A...F is represented as {A-F}.

Examples of pattern matching:
PatternMatches
ABCThe three-character string [a|A][b|B][c|C]
{ABC}{ABC}Any two-character string composed of capital letters A, B, or C
A?CAny three-character string that starts with a|A and ends with c|C
???Any three-character string
+?Any string, including the null string
+?{A-Z}Any string that ends in a capital letter
+{!A-Z}Any string that does not contain a capital letter

Usage

If the first or second parameter is a list, the function returns true if any element in the second parameter matches any element in the first parameter.

Language cross-reference

Like operator of LotusScript language

Example
See Also