RE: [sqlite] csv .import problems

2005-09-27 Thread Fred Williams
RP := j; end; end; Result := FS; end; - -Original Message- From: Antonio Francino [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 27, 2005 7:13 PM To: sqlite-users@sqlite.org Subject: [sqlite] csv .import problems 2 problems when importing da

[sqlite] csv .import problems

2005-09-27 Thread Antonio Francino
2 problems when importing data in sqlite3 with .import: 1. It leaves quotes in. If data field is enclosed in quotes, they are 'doubled'. (As reported in this list on Feb 16th) 2. When a string contains a comma, it is interpreted as separator, and an error is issued, of the type -"4 fields wer