re: CSV Import - Update with Commas in the Content

2008-10-20 Thread Ryan Stille
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

Re: CSV Import - Update with Commas in the Content

2008-10-20 Thread Azadi Saryev
yes, you need to either change your export routine to enclose all 'fields' in double quotes, or change your export format to, say, tab-delimited file instead of comma-delimited. most databases have built-in routines and functions to automate import of data from text files, in which you can usually