listToString

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)

ArgumentTypeDescription
arrayArrayList of values
separatorStringString to be used to separate the concatenated strings generated by the function
ignoreNullFlagBooleanFlag to determine whether NULL strings are ignored by the function (set to 1 or 0)
stringFormatStringOptional parameter representing the format to use for each element of the list.

Examples

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

listToString() returns "apple,1,John,,dog"

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

listToString() returns "apple--1--John----dog"

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

listToString() returns "apple--1--John--dog"

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

listToString() returns "01 Sep 2010--01 Oct 2010--01 Nov 2010"

See Also