The problem with using ListChangeDelims in this case is that it will treat the commas within quotes the same way as it treats the commas outside the quotes. That's part of the original problem.
--- Raymond Camden <[EMAIL PROTECTED]> wrote: > Instead of the Replace, don't forget you can use > ListChangeDelims. > > /CFDOCS/CFML_Reference/Functions137.html#1107244 > > ======================================================================= > Raymond Camden, Principal Spectra Compliance > Engineer for Macromedia > > Email : [EMAIL PROTECTED] > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - > Yoda > > > -----Original Message----- > > From: cf refactoring > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, November 02, 2001 9:32 AM > > To: CF-Talk > > Subject: RE: commas in lists > > > > > > Try this strategy: > > > > // default delimiter is a comma > > cfset myDelimiter="," > > //if > > If Find(yourList,'","') > > // replace "," by an unprintable character > > yourList = Replace(yourList,'","',CHR(7)) > > // Remove opening and closing " > > Replace(yourList,'"',"") > > // Change your delimiter to CHR(7) > > cfset myDelimiter=CHR(7) > > end if > > > > Now pass in myDelimiter along with your list > whenever > > you use CF's list manipulation functions > > > > P.S. I don't feel that this is a particular > deficiency > > of CF. I think making it "smart" enough to not > ignore > > quotes would be a bad thing. You just have to deal > > with it properly. > > > > > > > Well, this didn't work. CF ignors the > quotes > > > and treats all > > > > > commas it finds as delimiters > > > > > > > > > > Any ideas how I can allow a comma in the > list? > > > > > > > > CF is "stupid" about commas in lists, so, > here's > > > an idea... > > > > > > > > put ", in front of the list ," at the end and > use > > > "," as the delimiter ===== I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
