On Thu, Jul 30, 2015 at 12:58 PM, Sylvain Pointeau < sylvain.pointeau at gmail.com> wrote:
> I understood from the mailing list, that CSV is not a defined format, then > let's propose another format, well defined, the Excel one (which is in my > experience a format to is good every time I had to exchange CSV files). > > Then why don't you propose an import of CSV from Excel (or similar)? > csv(excel) > > is it possible? in a lot of cases, I cannot use sqlite (executable) because > of the lack of a good CSV import. It would really great if this could be > addressed. > > Best regards, > Sylvain > ?I am replying to your original message rather that later ones because I'm curious about the CSV file which is giving you a problem. Using the sqlite3 command on Linux Fedora 22 (64 bit), I get the following (transcript): $sqlite3 SQLite version 3.8.10.2 2015-05-20 18:17:19 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table test(name1 text, name2 text, name3 text); sqlite> .mode csv sqlite> .import ./test.csv test sqlite> .mode lines sqlite> select * from test; name1 = name1 name2 = name2 name3 = name3 name1 = line1a name2 = line1b name3 = line1c name1 = line2"a name2 = line2b name3 = 'line2b' sqlite> .quit joarmc at mckown5 2015-07-30T14:43:21 ~/junk $cat test.csv name1,name2,name3 "line1a",line1b,line1c "line2""a",line2b,'line2b' joarmc at mckown5 2015-07-30T14:43:25 ~/junk ? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
