ListChangeDelims() is wierd though in that it will allow you to replace a single delimiter with multiple delimiters eg:
listchangedelims(thislist, '","', ',') I find this unexpected behaviour in that other list functions only act on single delimiters. (ie listfind(thislist, 'myvalue', '",') uses '"' or ',' as delimiters, not '",'). I would expect multiple delimiters to be not allowed. I'm struggling to find the differences here between listchangedelims() and replace(). > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: 02 November 2001 14:46 > To: CF-Talk > Subject: RE: commas in lists > > > 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 > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
