joinarray() Function

Function

joinarray( array, separator )

Concatenates the elements of an array together into one string and inserts a string separator between each element.

Parameters

Returns

Text

Usage considerations

Acceptable array types

This function works with any array type, performing a string conversion on each element if necessary.

Null elements

Null elements cannot be concatenated. For example, joinarray({"", "", "", ""}, "|") returns null.

Understanding results

If no separator value is defined, then the values are concatenated without extra text. For example:

1
2
3
joinarray(
  {"Alice", "Donna", "Charles"}
)

Returns "AliceDonnaCharles".

If an array with only one element is entered as the array argument, the function will return only the element and no separator.

Examples

Join values with a single separator character

1
joinarray({1, 2, 3, 4}, "|")

Returns "1|2|3|4".

Join values with multiple separators

1
joinarray({1,2,3,4}, " < ")

Returns "1 < 2 < 3 < 4". Extra space is automatically trimmed from the start and end of the returned string.

Create a list of joined value strings with different separators

You can provide a list of separator values and Appian returns a List of Text String.

1
2
3
4
joinarray(
  {"Alice", "Donna", "Charles"},
  {"+", "-"}
)

Returns {"Alice+Donna+Charles", "Alice-Donna-Charles"}.

Feature compatibility

Feedback