Free cookie consent management tool by TermsFeed joinarray() Function
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

Keyword Type Description

array

Any Type Array

An array of elements to be concatenated.

separator

Text

A string that will be inserted between each element of the given array.

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

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

Real-Time Custom Record Fields Incompatible

Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.

Process Reports Compatible
Process Events Compatible

joinarray() Function

FEEDBACK