To return a string consisting of all items of the given string array separated by a given separator.

Merge multiple elements from an array or table into one string.

Unlike the function concat(), however, you can specify here which character should separate the elements. This can be a comma, for example, but also a line break. If you select a line break, you can output the entries in a multiline text field.

The function has nothing in common with the SQL statement of the same name.

Syntax

join([string], string)

Return

string

Examples

join(stringArray, separator) To return a string consisting of all items of the given string array separated by a given separator. The separator can be a line break.

join(["A", "B", "C"], "
")

Result: A B C

join((select Customer where Sales > 10000).Name, ", ")

Result: The names of all customers whose sales are higher than €10,000, one after the other, separated by commas.

See also

concat which returns all items of an array in one string.