FORMULA LANGUAGE

Examples: Concatenating, comparing, and determining length
1. (+). This example concatenates the two strings to form ABCDEF.
2. (+). This example concatenates the two input strings.
3. (=). This example returns True to YesNo if the two input strings are equal, False if they are not equal.
4. (@Length). This example displays 9, the length of abcdefghi.
5. (@Length). This example creates a number list. Each element of this list contains the length of the corresponding element in TextList.
6. (@Matches). This example returns True to YesNo if Input equals abc.
7. (@Matches). This example returns True to YesNo if every character in Input is alphabetic, that is, in the range a-z. The set {a-z} specifies the character range and the preceding + means any number of occurrences of the set.
8. (@Matches). This example returns True to YesNo if every character in Input is not alphabetic, that is, is outside the set {a-z}. The specification {!a-z} means not in the set of characters a-z, and the preceding + means any number of occurrences of that set.
9. (@Matches). This Example returns True to YesNo if Input contains the characters bc in sequence surrounded by any number of any characters.
10. (@Matches). This Example returns True to YesNo if Input starts with a and is three characters long or starts with 1 and is three characters long.
11. (@Like). This agent example checks for two sets of strings in the textBody field of each document. The first string is any text that contains "acquisition" and "Acme" in that order. The second string is any text that contains "Acme" and "51%" in that order. The second @Like statement uses the slash (/) as an escape character so the percent sign (%) can be specified. Don't use the backslash (\) as an escape character.
12. This action compares a list to the value "N" and displays the result. Boston and Moscow result in -1 (less than N), Tokyo results in 1 (greater than N), and n and N result in 0.
See Also