Err... no. If you pass ", " to a CF list function, it will NOT treat ", " as the delimiter. Rather, it will treat both commas and spaces as possible delimiters. There is no way, in CF list funcs, to have a multi-char delimiter. You can, however, loop through the string manually. Another option is the RESplit UDF at cflib.org. If you pass "," as the splitter, it will work, but each element will be missing a " at the beginning or end - but that's easy enough to correct.
======================================================================= Raymond Camden, ColdFusion Jedi Master for Macromedia Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 5:36 AM > To: CF-Talk > Subject: RE: list delimiter problem > > > If you don't have any other variations in the list, you could > use the fact > that >Elements, a source bo< has a space after the , > > so list delimiters could be all of the following....... > "," > ", > ," > > then you need to stop it from using ", " (comma space, > without quotes) as a > delimiter. > > Or if you want to change the comma space into something more > useful as a > delimiter. > > I hope that explained it ok. > > Ade > > -----Original Message----- > From: Seamus Campbell [mailto:[EMAIL PROTECTED]] > Sent: 12 June 2002 07:28 > To: CF-Talk > Subject: list delimiter problem > > > Hi > > I have a list - the format of which I cannot change. One line > as an example > below > > "SUS","DECORA","1903141001","Garden Elements, a source book > of decorative > ideas to transform the garden","CLIFTON JOAN",45.00,0,"HB","2000", > > Sometimes there is a comma in the title as above so when I am > inserting/updating the contents into a database > > Garden Elements is taken as one field > and > a source book of decorative ideas to transform the garden > as another > > I am trying to change the delimiters but I can't work out how > to not to > change the comma, for instance, inside the title field > "Garden Elements, a source book of decorative ideas to > transform the garden" > > Does anyone have any clues please > > Seamus > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
