Concat

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 " */