I've got a feeling he may be asking for something that can handle qualified, delimited lists, such as:
"Item one","Item two, with a comma","Item three","Item four" Often, I've had to deal with lists in which the qualifiers are optional, but are needed when an item contains either whitespace or the list delimiter itself: "Item one",2,"The third one","Four, five, six.",5,6,Seven And, of course, CF's list handling doesn't treat empty list items the way most programs do: "One and",2,,-4,"Five",,,8,"The ninth" Jim ----- Original Message ----- From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 03, 2002 12:32 PM Subject: RE: comma to tab > ListChangeDelims() will replace any list delimiter with another. > > ======================================================================= > 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: Eric J Hoffman [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, February 03, 2002 2:05 PM > > To: CF-Talk > > Subject: comma to tab > > > > > > Is there a custom tag or easy method to take a comma > > delimited list and > > convert it to tab delimited...something better and more > > robust than trying > > some sort of rereplace madness? > > > > I see some in the gallery to output from data queries, but we > > are merging > > two comma delim files but the client's client demands tab > > delimited data > > returned to them. Quick pointers are appreciated! > > > > Regards, > > > > Eric J. Hoffman > > Director of Internet Development > > DataStream Connexion, LLC > > (formerly Small Dog Design) ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
