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
?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
!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
ABC"ABC"
{ABC}{ABC}Two capital letters
A?CAny three­character string that starts with "A" and ends with "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

Language cross-reference

Like operator of LotusScript language

Example
See Also