...
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"