Damayanti Gupta wrote:
> However, one of my array elements has a comma - like  ff,gg. This gets split 
> into 2 elements, which I don't want. Is there any way around this?

You can select a different delimiter for the list to manage it 
internally, such as:

aList = ArrayToList(anArray, chr(255));

Of course, you would then need to use chr(255) as the delimited for any 
other list functions you're using after that.  For the CSV output, you 
can use ListChangeDelims() to convert from chr(255) back to a comma 
before output.

Depending on the application that you're exporting to, you may want to 
wrap the individual list elements in double-quotes so the comma is 
preserved in the data there, so the output would look like:

"aa","bb","cc","dd,ddd","ee","ff" ...

You can use ListQualify() to do that for you before you convert the 
delimited back to a comma.


-- 
Justin Scott | GravityFree
Network Administrator

1960 Stickney Point Road, Suite 210
Sarasota | FL | 34231 | 800.207.4431
941.927.7674 x115 | f 941.923.5429
www.GravityFree.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316789
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to