Re: loadfile with quotation marks -> csv-file

Hello, thanks for your interest, Jonathan. As i write before, sqlreload doesn't work. As i understand, i can only use sqlreload for an input file (-i) - right ? -> sqlcmd: invalid option i Or have i made a mistake ? The Question is'nt how i would embed a double quote inside a field enclosed in double quotes, but how would do this excel: 1,"""ABC,D""" 2,"ABC,D" First line is with double quote as input ("ABC,D"), second line only letters (ABC,D). DBD::CVS isn't a complete solution, but you can use this module to create your own solution. The perl script i found is a complete solution... It might be useful for others, when a tool for Informix exist, that can handle CSV files (don't forget the first line, that is the field names), because Informix can't handle that (but other databases can handle CSV files). Regards, try_and_err >Maybe, but probably not. I would have tried SQLCMD first (mainly >because I wrote it), and I'd worry about whether it handled the >"ABC,DEF" field correctly (and the other unquoted non-numeric strings). > I need to investigate, and fix if necessary. How would you embed a >double quote inside a field enclosed in double quotes? > >If that failed, I'd look at DBD::CSV and related Perl stuff.