Thanks. I'm not sure if your method is quicker, but it allows me to break my list wherever I need to.
-----Original Message----- From: Claude Schneegans [mailto:schneeg...@internetique.com] Sent: Monday, October 05, 2009 12:00 PM To: cf-talk Subject: Re: Splitting a list... >><cfset thelist ="aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz"> What would be the most efficient way to split the list into two lists, Try this : <cfset thelist ="aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz"> <CFSET st = REFind ("([^\,]*\,){6}", thelist, 1, true)> <CFSET list1 = mid(theList, 1, st.len[1]-1)> <CFSET list2 = mid(theList, st.len[1]+1, 9999)> <CFOUTPUT> list1 = #list1#<BR> list2 = #list2#<BR> </CFOUTPUT> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4