TEXTJOIN Function: Difference between revisions
From Planfix
No edit summary |
|||
| Line 2: | Line 2: | ||
|title=TEXTJOIN Function | |title=TEXTJOIN Function | ||
|titlemode=append | |titlemode=append | ||
|keywords=planfix,functions, TEXTJOIN, TEXTJOIN Function | |keywords=planfix, functions, TEXTJOIN, TEXTJOIN Function | ||
|description=TEXTJOIN Function | |description=TEXTJOIN Function | ||
}} | }} | ||
| Line 8: | Line 8: | ||
== Format == | == Format == | ||
'''TEXTJOIN('''delimiter;ignore_empty;multiplied_variable | '''TEXTJOIN('''delimiter;ignore_empty;multiplied_variable''')''' | ||
Where: | Where: | ||
Revision as of 13:35, 14 May 2024
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