On 1-5-2018 16:20, Simon Slavin wrote: > 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. >
You 'forgot' this link: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8-mso_2010/sep-support-for-older-excel/293076a3-6593-4ceb-8167-d29aa3418773 ;) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users