I'm not sure I understand. Are you saying they are providing you data that has delimiters within the data, but the data is not quoted? Like: [EMAIL PROTECTED],Joe,Smith,Joe, John & Sons Inc. If so there is nothing you can do about that, they need to be properly quoting (with double quotes or some other identifier) data that contains the delimiter, like this: [EMAIL PROTECTED],Joe,Smith,"Joe, John & Sons Inc." Then you need a data import routine that can correctly handle that. Most of the ColdFusion CSV handling code I come across does not handle this very well. -Ryan
---------------------------------------- From: Michael Grove <[EMAIL PROTECTED]> Sent: Monday, October 20, 2008 8:27 PM To: cf-talk <[email protected]> Subject: CSV Import - Update with Commas in the Content I am trying to figure out how to update a sql table using a CSV file that has commas in the data fields. The long and Short of it, is that we have a SEO company rewriting our keywords, meta descriptions and titles for our product database. We were able to build a simple CSV export so that they could add the new info. Now we need a way to import it back into the systm and update all of the records based on the productID, wich is in the csv file. The developer we are using says it can be done, but we cannot have commas in any of the fields. We can wrap the columns in double quotes on an export, cant we do this on the import? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
