The importer is broken. The quotes surrounding each field imply that the field is terminated by a quote as well, so any commas within the quoted string are NOT field separators. That's part of both standard CSV and Excel's slightly modified dialect. If the importer truly splits on every comma instead of respecting quoted fields, you'll either need to use a different delimiter (per Jason's suggestion), or escape the commas in some way.
cheers, barneyb On Tue, Feb 24, 2009 at 12:43 PM, Jason Fisher <[email protected]> wrote: > > You're not doing anything wrong, any system that tries to import the CSV will > automatically assume that every comma is a field delimiter, just like it's > supposed to do. If you have content with commas in, you'll have to pick a > different field delimiter, like Tab or pipe (|). > > Example with pipes: > <cfsavecontent variable="csv"> > "Email Address"|"First Name"|"Last Name"|"Company"|"Address Line 1"|"Address > Line 2"|"City"|"State"|"Postal Code" > <cfoutput > query="myQ">"#RTRIM(EMAIL)#"|"#RTRIM(FIRSTNAME)#"|"#RTRIM(LASTNAME)#"|"#RTRIM(COMPANY)#"|"#RTRIM(ADDRESS1)#"|"#RTRIM(ADDRESS2)#"|"#RTRIM(CITY)#"|"#RTRIM(STATE)#"|"#RTRIM(ZIP)#"</cfoutput> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
