The Concat()
function strings together a list of texts.
Syntax
Concat(values)
Concat(values, delimiter)
Concat(values, delimiter, last_delimiter)
Returns
A new text that consists of the given values
that are all concatenated, optionally
separated by the given delimiters.
Parameters
values
a list of texts.delimiter
(optional) is pasted between the texts when they are stringed together.last_delimiter
(optional) is pasted between the last two texts.
Examples
Concat(List("Apple", "Google", "Microsoft"))
/* returns "AppleGoogleMicrosoft" */
Concat(List("Apple", "Google", "Microsoft"), ", ")
/* returns "Apple, Google, Microsoft" */
Concat(List("Apple", "Google", "Microsoft"), ", ", " or ")
/* returns "Apple, Google or Microsoft" */
Concat([Products.Name] of [Products], ", ", " or ")
/* returns the product names of all items in the Products list, separated by commas. The last two products are seperated by " or " */