ListToArray

Description

Copies the elements of a list to an array.

Return value

An array

Syntax

ListToArray(list [, delimiters ])

Parameters

Parameter Description

list
A list or a variable that contains one.
You define a list variable with a cfset statement.

delimiters
A string or a variable that contains one. Character(s) that separate list elements. Default: comma.
If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.

Parameter	Description
list	A list or a variable that contains one. You define a list variable with a `cfset` statement.
delimiters	A string or a variable that contains one. Character(s) that separate list elements. Default: comma. If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.

Usage

ColdFusion ignores empty list elements; thus, the list "a,b,c,,,d" has four elements.

Example

<h3>ListToArray Example</h3>
<!--- Find a list of users who wrote messages --->
<cfquery name = "GetMessageUser" datasource = "cfsnippets">
SELECT Username, Subject, Posted
FROM  Messages
</cfquery>
<cfset myList = ValueList(GetMessageUser.UserName)>
<p>My list is a list with <cfoutput>#ListLen(myList)#</cfoutput>
 elements.
<cfset myArrayList = ListToArray(myList)>
<p>My array list is an array with <cfoutput>#ArrayLen(myArrayList)#
 </cfoutput> elements.

Version 6

Comments are no longer accepted for ColdFusion MX. ColdFusion 8 is the current version.

Comments

TomGru said on Jan 31, 2005 at 6:29 AM :

Ist there any solution for the "empty list elements" problem? I've a textfile import with some empty list elements. How can i avoid errors?

TomGru said on Jan 31, 2005 at 6:44 AM :

I've found a solution. Replace the empty vals with a Space.

<CFFILE ACTION="Read" FILE="c:/test.test.csv" VARIABLE="shtmlfile" >
<CFSET zeile = ListToArray(shtmlfile, "
")>

<cfset laenge = ArrayLen(zeile)>

<cfloop index="i" from="1" to=#laenge # step="1">
<cfset StrEmptyValReplace=#replace(zeile[#i#],';','; ',"all")#> 
<CFSET Feld = ListToArray(StrEmptyValReplace, ";")>

<cfoutput>
Col1 : #Trim(Feld[1])#<br>
Col2 : #Trim(Feld[2])#<br>
Col3 : #Trim(Feld[3])#<br>
Col4 : #Trim(Feld[4])#<br>
</cfoutput>
</cfloop>

RSS feed | Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt221.htm