Text function rule examples

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:

Rule examples

Function Example rule Inputs Outputs
Contains

the account may be a benefit account if

Contains(the account name, "benefit")

the account name: "Special Benefits" the account may be a benefit account = true
Concatenation

the screen heading variable for the person = the concatenation of the person's first name & ", " & the person's age & ", " & the person's occupation

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 uses the ascending sort code if

EndsWith(the product code, "-ASC")

the product code: "B421-A3N-ASC" the product uses the ascending sort code = true
IsNumber

the postcode is a valid Australian postcode if

IsNumber(the postcode) and Length(the postcode) = 4

the postcode: "2612" the postcode is a valid Australian postcode = true
Length

the product code is valid if

Length(the product code) > 8

the product code: "123456789" the product code is valid = true
StartsWith

the person should be represented if

StartsWith(the person's name, "Sir")

the person's name: "Sir Lancelot" the person should be represented = true
Substring

customer reference = Substring(customer name, 4, 4)

customer name: "maryjane"

offset: 4

length: 4

customer reference = "jane"
Text

age text = Text(age value)

age value: 25 age value = "25"

 

See also: