On 1 May 2018, at 3:01pm, Olivier Mascia <o...@integral.be> wrote: > 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.
What kind of insanity would lead someone to invent semi-colon delimited format when CSV already existed ? I bet it was a badly-thought-out solution for European numeric formats which use a comma as a decimal point. Tell whoever uses that format to stop. Seems like the best way to solve this would be to write a converter for Windows which converts SCSV to CSV. Then it could be used by all Excel users instead of just SQLite users. Take a look at <https://blogs.technet.microsoft.com/heyscriptingguy/2011/10/18/convert-a-semicolon-delimited-file-to-a-csv-file/> <https://social.technet.microsoft.com/Forums/windows/en-US/370ee470-f2cd-4f30-a167-b106dd51d47a/powershell-convert-csv-to-xlsx> and hack up a solution. I'd do it myself but I don't use Windows. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
