Re: [PATCHES] Note that spaces between QUOTE and DELIMITER are included

2005-09-05 Thread Andrew Dunstan
I wrote: In CSV mode all characters are significant. A quoted value surrounded by white space, or any characters other than DELIMITER, will include those characters. This can cause errors if you import data from a system that pads CSV lines with white space out to some fixed width. If s

Re: [PATCHES] Note that spaces between QUOTE and DELIMITER are included

2005-09-02 Thread Andrew Dunstan
I wrote: Darcy Buskermolen wrote: + CSV mode will include all characters between QUOTE and + DELIMITER in the value for the field, this is of special + attention to those who use CSV mode to import data from other RDBMS + systems that create fixed width CSV files.

Re: [PATCHES] Note that spaces between QUOTE and DELIMITER are included

2005-09-02 Thread Bruce Momjian
> + > + > + CSV mode will include all characters between QUOTE and > + DELIMITER in the value for the field, this is of special > + attention to those who use CSV mode to import data from other RDBMS > + systems that create fixed width CSV files. > + > + So

Re: [PATCHES] Note that spaces between QUOTE and DELIMITER are included

2005-09-02 Thread Andrew Dunstan
Darcy Buskermolen wrote: + CSV mode will include all characters between QUOTE and + DELIMITER in the value for the field, this is of special + attention to those who use CSV mode to import data from other RDBMS + systems that create fixed width CSV files. First, t