TEXTJOIN Function: Difference between revisions
From Planfix
No edit summary |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| 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: | ||
| Line 21: | Line 21: | ||
== Important == | == Important == | ||
You can pass the result of the [ | You can pass the result of the [[UNIQUE Function|UNIQUE()]] function to the TEXTJOIN() function: | ||
<pre>%%%TEXTJOIN(" + ";1;UNIQUE({{Data tag.Actual working time.Employee.Name}}))%%%</pre> | <pre>%%%TEXTJOIN(" + ";1;UNIQUE({{Data tag.Actual working time.Employee.Name}}))%%%</pre> | ||
| Line 30: | Line 30: | ||
== Go To == | == Go To == | ||
*[[ | *[[Standard functions|Formulas]] | ||
Latest revision as of 13:36, 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