Problems with LOAD DATA

[Michael Staley]

I load data from CSV files using the LOAD DATA utility. Where there is an embedded comma in text data, the field is enclosed with double quotes, and I am using the clause "OPTIONALLY ENCLOSED BY '"'. Unfortunately, the double quotes are ignored, and the comma is taken to indicate a new field.

Has anyone else had this problem, and if so is there a work-around?

Any help greatly appreciated. In the meantime, I'm have written an Applescript application to take the CSV file and produce from it SQL INSERT statements, but I'd still like to find a solution to the LOAD DATA problem if possible.