Text functions are used with text variables to combine text strings and to extract parts of text strings. NOTE: Text functions are case-insensitive.
Be sure to use the exact syntax for these functions including spacing and parentheses as specified below.
TIP: The localized syntax for these functions may be viewed:
Function | Example rule | Inputs | Outputs |
---|---|---|---|
Contains |
|
the account name: "Special Benefits" | the account may be a benefit account = true |
Concatenation |
|
the person's first name: William the person's age: 20 the person's occupation: Student |
the screen heading variable for the person = "William, 20, Student" |
EndsWith |
|
the product code: "B421-A3N-ASC" | the product uses the ascending sort code = true |
IsNumber |
|
the postcode: "2612" | the postcode is a valid Australian postcode = true |
Length |
|
the product code: "123456789" | the product code is valid = true |
StartsWith |
|
the person's name: "Sir Lancelot" | the person should be represented = true |
Substring |
|
customer name: "maryjane" offset: 4 length: 4 |
customer reference = "jane" |
Text |
|
age value: 25 | age value = "25" |
See also: