Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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"])

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

  • No labels