On 1 May 2018, at 11:11am, Olivier Mascia <o...@integral.be> wrote: > 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
