To return all items of an array in one string

This function returns values from an array, a table, or a multiple-choice field one after the other separated by a comma in a text field or a text variable. It’s used to reflect the selected options of a multiple-choice field as a running text, for example in forms or print layouts.

It’s often used for intermediate steps within a script.






concat('Last name', 'First name') 

Result: Böhmer, Frank (with Last name = Böhmer and First name = Frank)

See also

join, which returns a string of all items of a given string array by a given separator.

Do you want to dive deeper into the topic? Take a look at the corresponding part of our video tutorial.

Last updated