News for hackers. Stuff that matters.
Re:Design Better Data Tables by kriro on Monday March 06, 2017 @08:43AM (#13802549)
You can select the separator when opening the file in LibreOffice Calc (don't have Excel on this machine but I know it's possible as well). Setting it to ";" fixes this for all European data sets I have worked with that use "," where "." would be used in the U.S. You can also specify the separator in pretty much every other tool that imports CSV (for example in R).
Re:Design Better Data Tables by rb808 on Monday March 06, 2017 @08:50AM (#13802585)
Pipe | is even better.