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) |
| stringFormat | String | Optional parameter representing the format to use for each element of the list. |
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"