- 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 -<
