0

concat

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.

 

Syntax

concat([any])

 

Returns

string

 

Examples

concat('Last name', 'First name') 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.

Reply

null