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