TEXTJOIN Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=TEXTJOIN Function |titlemode=append |keywords=planfix,functions, TEXTJOIN, TEXTJOIN Function |description=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 == <pre>%%%TEXTJOIN("; ";1;{{Task.Assignee.Name}})%%%</pre> The result will be a string in which the...") |
|||
| Line 21: | Line 21: | ||
== Important == | == Important == | ||
You can pass the result of the [ | You can pass the result of the [UNIQUEFunction|UNIQUE()]] function to the TEXTJOIN() function: | ||
<pre>%%%TEXTJOIN(" + ";1; | <pre>%%%TEXTJOIN(" + ";1;UNIQUE({{Data tag.Actual working time.Employee.Name}}))%%%</pre> | ||
Result: | Result: | ||
<pre>Mike + Peter</pre> | <pre>Mike + Peter</pre> | ||
== Go To == | == Go To == | ||
*[[Функции]] | *[[Функции]] | ||
Revision as of 08:24, 8 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 [UNIQUEFunction|UNIQUE()]] function to the TEXTJOIN() function:
%%%TEXTJOIN(" + ";1;UNIQUE({{Data tag.Actual working time.Employee.Name}}))%%%
Result:
Mike + Peter