Free cookie consent management tool by TermsFeed

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

Feedback