PhixFlow Help

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

« Previous Version 2 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)

ArgumentTypeDescription
arrayArrayList of values
separatorStringString to be used to separate the concatenated strings generated by the function
ignoreNullFlagBooleanFlag to determine whether NULL strings are ignored by the function (set to 1 or 0)
stringFormatStringOptional 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