strcat-array-function.md

title	description	ms.reviewer	ms.topic	ms.date
strcat_array()	Learn how to use the strcat_array() function to create a concatenated string of array values using a specified delimiter.	alexans	reference	08/11/2024

strcat_array()

[!INCLUDE applies] [!INCLUDE fabric] [!INCLUDE azure-data-explorer] [!INCLUDE monitor] [!INCLUDE sentinel]

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

Syntax

strcat_array(array, delimiter)

[!INCLUDE syntax-conventions-note]

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

:::moniker range="azure-data-explorer"

[!div class="nextstepaction"] Run the query ::: moniker-end

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.

:::moniker range="azure-data-explorer"

[!div class="nextstepaction"] Run the query ::: moniker-end

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

Output

str
1"2"3