Join Texts
Join Texts
Joins the items of a list into a single text, interleaving them with a defined separator. It also allows joining only a part of the list, by indicating the start and end positions. The natural complement of the Separate text action, useful for rebuilding data after processing or assembling formatted strings such as lists, paths or queries.
Options
Enter the separator character
Enter the character or excerpt that will be inserted between each item when the text is joined. For example, a comma, a semicolon or any other delimiter. The default value is the dot (.).
Words that will be joined to the text
Enter the list of words or values that will be concatenated. Each item of the list will be included in the result separated by the character defined above.
Advanced options
Start
Position of the first list item included in the join. Counting starts at 0.
End
Position where the join ends. The item at this position is not included.
Returns
Javascript code
actions["action-id"].value // text resulting from joining the items (Text)
Field selection
- value — joined text with the separator applied between the items (Text)
Rules and Conditions
- With Start and End equal to 0 (default), all the items of the list are joined.
- If only Start is provided and End is left at 0, the result is empty — provide the End as well.
- Items that are lists are expanded, and their elements are joined individually.
- If the list is empty, the result is an empty text.