> Le 1 mai 2018 à 14:00, Simon Slavin <slav...@bigfraud.org> a écrit : > >> CREATE VIRTUAL TABLE temp.t1 USING csv(filename='thefile.csv'); >> >> Is there any way to teach the csv extension to use ';' instead of ',' as the >> column delimiter, getting away from the strict RFC4180 definition? > > The source code for the csv extension is in the archive. Make your own > version called 'ssv'. > > Or, if you can rely on strings in the file not having commas in them, use a > simple shell tool to replace all commas with semicolons.
Thanks a lot for the answer Simon, even though I knew of these solutions. :) My question was more generic, even though it didn't look that way: the well-known and (maybe too) much-used software tool named Excel tend to encourage people to export "CSV" files which are actually "SCSV" files (semi-colon separated values). So the need to script some data happens regularly. Very easy for programmers like you and me. A bit harder for people just trained enough for some simple sqlite command-line interactions, they might not have the right tool / script-languages knowledge to do it easily or more importantly to do it right. Nothing really important. Just wanted to trigger some thinking. Again, thank you. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
