strcat_array()

Creates a concatenated string of array values using a specified delimiter.

Syntax

strcat_array(array, delimiter)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
array	dynamic	✔️	An array of values to be concatenated.
delimeter	string	✔️	The value used to concatenate the values in array.

Returns

The input array values concatenated to a single string with the specified delimiter.

Examples

Custom delimeter

Run the query

print str = strcat_array(dynamic([1, 2, 3]), "->")

Output

str
1->2->3

Using quotes as the delimeter

To use quotes as the delimeter, enclose the quotes in single quotes.

Run the query

print str = strcat_array(dynamic([1, 2, 3]), '"')

Output

str
1"2"3