Re: loadfile with quotation marks -> csv-file

ok, maybe my first explanation was to simple (or false): We have a standard CSV file (comma separated) from an extern firma to insert in an Informix table, like this: 1,ABC,"ABC,DEF",DEF,2,,, 2,BCD,EFG,"BCD,EFG",2,,, There were three problems (for Informix/dbaccess): - double quotes - comma in double quotes identified as delimiter - last column without finally delimiter (table has 8 columns) ok, i can write an (awk) script to fix these problems, but i am surprised that is it really not possible to load an normal and standard CSV file in Informix ? sqlreload doesn't work: env | grep DB DBQUOTE=" DBDELIMITER=, sqlreload -d db1 -i test1.csv -t test1 -v -x SQL -846: Number of values in load file is not equal to number of columns. ISAM -746: Too many values in record It seems, that the comma in double quotes is already identified as delimiter... I have tried with and without an additionally delimiter (comma). Further suggestions ? Regards, try_and_err