Function: listToString()

This function takes a list and returns a string which is the concatenation of the string representation of each element of the list, with each element separated by a comma.

Null values will be returned as empty strings (see example 1).

Syntax

listToString(array)

listToString(array, separator)

listToString(array, separator, ignoreNullFlag)

listToString(array, separator, ignoreNullFlag, stringFormat)

Argument	Type	Description
array	Array	List of values
separator	String	String to be used to separate the concatenated strings generated by the function
ignoreNullFlag	Boolean	Flag to determine whether NULL strings are ignored by the function. Set to 1 or 0, where 1 is ignore and 0 is include. By default NULL values are included.
stringFormat	String	Optional parameter which applies to dates only. This represents the format to use for each element of the list where the list items are dates.

Examples

listToString(["apple",1,"John",NULL,"dog"])

returns

"apple,1,John,,dog"

listToString(["apple",1,"John",NULL,"dog"],"--")

returns

"apple--1--John----dog"

listToString(["apple",1,"John",NULL,"dog"],"--",1)

returns

"apple--1--John--dog"

listToString([01/09/2010,01/10/2010,NULL,01/11/2010],"--",1,"dd MMM yyyy")

returns

"01 Sep 2010--01 Oct 2010--01 Nov 2010"

HELP100

listToString

Analytics

Function: listToString()

Syntax

Examples

See Also

Related content