TEXTJOIN Function

TEXTJOIN() Function combines values in a list with a predefined delimiter.

Format

TEXTJOIN (delimiter;ignore_empty;multiplied_variable)

Where:

• ignore_empty — valid values are 1 (yes) and 0 (no).

Example

%%%TEXTJOIN("; ";1;{{Task.Assignee.Name}})%%%

The result will be a string in which the elements from the variable are stored through the delimiter:

Robot 2; Tomas

Important

You can pass the result of the UNIQUE() function to the TEXTJOIN() function:

%%%TEXTJOIN(" + ";1;UNIQUE({{Data tag.Actual working time.Employee.Name}}))%%%

Result:

Mike + Peter

Go To

• Formulas