3 ms·
I hate csv so much. Simply opening a csv in Excel and saving it breaks the format so much that most parsers cannot understand it anymore. Plus there is no way t
by slowmotiony 9y ago
I hate csv so much. Simply opening a csv in Excel and saving it breaks the format so much that most parsers cannot understand it anymore. Plus there is no way to know which encoding the csv came in - Notepad++ might say one thing and PowerShell will say another. Have fun figuring out why cyrrilic characters or umlauts cause issues in your scripts...
- carlps 9y agoI think the excel issue is a problem with excel, not csv. Why can't excel preserve the format of the file?
- jarman 9y agoProblem is not CSV, it's Excel. It's hard to blame format, when application is insane enough to use locale settings to determine file parsing
- deleted 9y ago[deleted]
- jarman 9y ago>why cyrrilic characters or umlauts cause issues in your scripts... Any text format can be broken by broken character encoding. I saw plenty of XML being used without any charset declarations. And JSON is in same position as CSV.