Join Text Collection action

The Join Text Collection action concatenates a list of text values into a single text value, with delimiter, enclosure and escape character options.

Input values

Input Value	Description
Delimiter	A character used to separate individual text values in the given collection. Useful for formatting CSV values or a list of values to inject into a SOQL query.
Enclosure	A character used to wrap each text value. Primarily used for formatting CSV values or a list of values to inject into a SOQL query.
Escape Character	The special character prepended to the enclosure character when enclosing a value that contains the enclosure character.
Text Collection	The collection of text values to join together into a single text value.

Examples

Text Collection	Delimiter	Enclosure	Escape Character	Output
a b c	Don't Include	Don't Include	Don't Include	abc
a b c	,	Don't Include	Don't Include	a,b,c
a b c	,	"	Don't Include	a,b,c
a b c	,	"	Don't Include	"a","b","c"
a b null c	,	"	Don't Include	"a","b","","c"
Simon says "Please, eat your peas."	,	"	\	"Simon says",""Please, eat your peas.""
Simon says "Please, eat your peas."	,	"	"	"Simon says","""Please, eat your peas."""