FORMULA LANGUAGE

List concatenation operator
The list concatenation operator (:) concatenates values into a list. The values must all be of the same type. This example is a three-member text list.

"London" : "New York" : "Tokyo"

The values can be constants, variables, and expressions, including other lists.

LNY := "London" : "New York";
LNY : "Tokyo"

Since list concatenation has the highest precedence next to subscripts, list elements that are expressions must be in parentheses. In the following example, the minus sign has the unintended effect of applying to both the third and fourth elements of the second list.

1:2:3:4 + 1:2:-3:4 = 2:4:0:0

Use parentheses to make the minus operation apply only to the third element of the second list.

1:2:3:4 + 1:2:(-3):4 = 2:4:0:8