>- see footer for list info -< Try this: <CFSET List = '"a,a","b","c"'> <CFSET List = Replace(#List#,'",','";',"ALL")> <CFOUTPUT>#list#<BR> <CFLOOP LIST="#list#" INDEX="ind" DELIMITERS=";">#ind#<BR></CFLOOP> </CFOUTPUT>
Allan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of dominic watson Sent: 04 October 2005 11:40 To: Coldfusion Development Subject: Re: [CF-Dev] CSVs with quote marks to qualify strings >- see footer for list info -< There are 18 values, not all strings, but all are surrounded by quotes in that format. Each newline also begins with '=' so: "a","b","c", ="a","b","c" ="a","b","c" thanks Allan Cliff wrote: >>- see footer for list info -< >> >> >Are the 3 values always going to be strings? > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of dominic watson >Sent: 04 October 2005 11:33 >To: Coldfusion Development >Subject: [CF-Dev] CSVs with quote marks to qualify strings > > > > >>- see footer for list info -< >> >> >I am converting a csv into a list that I use to update a database. The >problem I have is where items contain a comma like so: > >"Title, the","author","ISBN" > > >I have tried making the delimeter for a list '","' but it still cuts >"Title, the" into two items. Does anyone have a solution? > > >Thanks, > >Dom > > >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > > >>- Hosting provided by www.cfmxhosting.co.uk -< >>- Forum provided by www.fusetalk.com -< >>- DHTML Menus provided by www.APYCOM.com -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your >>help >> >> > > > >>-< >> >> > >______________________________________________________________________ >This email has been scanned by the MessageLabs Email Security System. >For more information please visit http://www.messagelabs.com/email >______________________________________________________________________ >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > > >>- Hosting provided by www.cfmxhosting.co.uk -< >>- Forum provided by www.fusetalk.com -< >>- DHTML Menus provided by www.APYCOM.com -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your >>help -< >> >> > > > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
