| Excerpt | ||
|---|---|---|
| ||
listToString(array) Takes a list and returns the concatenation of the values in that list. |
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.
...
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"])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"