Edit

Share via


STRINGJOIN ER function

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The STRINGJOIN function returns a String value that consists of concatenated values of the specified field from the specified list. The values can be separated by the specified delimiter.

Syntax

STRINGJOIN (list, field, delimiter)

Arguments

list: Record list

The valid path of a data source of the Record list data type.

field: Field

The valid path of a field of the String data type in the specified list.

delimiter: String

A delimiter that is used to separate substrings.

Return values

String

The resulting text value.

Example

If you enter SPLIT("abc" , 1) as data source DS, the expression STRINGJOIN (DS, DS.Value, "-") returns "a-b-c".

Additional resources

List functions