Lotus Domino Designer 8.5 Help - Examples: @Matches

FORMULA LANGUAGE

Examples: @Matches
1. This example returns 0.

@Matches("A big test";"a?test")

2. This example returns 1.

@Matches("A big test";"a?????test")

3. This example converts the contents of the State field to lowercase, and returns 1 for any value in the field that contains "mont," for example Vermont or Montana.

@Matches(@Lowercase(State);"*mont*")

4. This example is the default value formula for a field named SalesNumber. The formula returns the number 224 if the content of the Division field is either Central or Midwest. If the content of Division is anything else, the formula returns the number 124.

@If(@Matches(Division;"Central | Midwest");224;124)

5. This code, when added as the validation formula for a number field called input, displays the error message, "Value cannot be a letter" if the user enters any lowercase or uppercase letter between A and Z.

@If(@Matches(@Text(input);"+{!A-z}");@Success;@Failure("Value cannot be a letter"))

Note The validation error message is also triggered if the user enters a backslash, underscore, or square brackets because specifying A-z, specifies all ASCII characters between the uppercase A and lowercase z. The backslash, underscore, and square brackets are included in this set of characters.

6. This code, when added as the validation formula for the US_State editable text field, displays the error message, "Entry must be a valid two-letter state abbreviation" if the user enters anything besides two upper-case letters.

@If(@Matches(US_State;"{A-Z}{A-Z}");@Success;@Failure("Entry must be a valid two-letter state abbreviation"))

7. This example returns 0 because no item in the second list matches an item in the first list.

@Text(@Matches("one" : "two" : "three"; "four" : "five" : "six"))

8. This example returns 1 because one item in the second list matches an item in the first list.

@Text(@Matches("one" : "two" : "three"; "three" : "four" : "five" : "six"))

See Also

@Matches

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary