Cfloop and list

[jorgepino]

thru a form i recieve several list
form.list1 ( 123,$15,000,$15,000,$15,000,x)
form.list2 (456,$4,000,$15,000,$15,000,s
form.list3 (789,$7,000,$1,000,$15,000,x)
form.list4 (987,$15,000,$15,000,$800,s)
form.list5 (654,$15,000,$750,$15,000,x)
etc etc
I need to move it an array
but i keep getting problem with the ","
any ideas

thanks

[Stressed_Simon]

ListToArray() function is a good start. Although I was told that it was quicker to loop through the list and use ArrayAppend() but that is your call.

HTH

[jorgepino]

sounds good
but how do i solve the problem with the "," within the dollar amount and "," as a delimeter?

[Stressed_Simon]

Try this:-

<cfscript>
// set lists
form.list1 = "123,$15,000,$15,000,$15,000";
form.list2 = "456,$4,000,$15,000,$15,000";
form.list3 = "789,$7,000,$1,000,$15,000";
form.list4 = "987,$15,000,$15,000,$800";
form.list5 = "654,$15,000,$750,$15,000";

// create new struct to hold arrays
ListHolder = StructNew();

// loop through lists
for (i = 1; i LTE 5; i = i + 1) {
ListHolder["list" & i] = ArrayNew(1);

// swap comma dollar delimiter
FORM["list" & i] = Replace(FORM["list" & i], Chr(44) & Chr(36), Chr(124),
"ALL");

// create array
ListHolder["list" & i] = ListToArray(FORM["list" & i], Chr(124));
}
</cfscript>

<cfdump var="#ListHolder#">