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

 +31 (0)20 240 21 20       

Videos and images courtesy of WEM Modeler. © 2019. WEM Modeler.
SitemapPrivacy - Terms - Company

 +31 (0)20 240 21 20       


Videos and images courtesy of WEM Modeler.
© 2019 WEM Modeler.
SitemapPrivacy - Terms - Company