Re:Scientists rename human genes to stop MS Excel from misre...
by ellis-bell on Thursday August 06, 2020 @02:00PM
(#24073653)
makes sense!
fwiw, i have not tried to use libreoffice for any heavy lifting, unfortunately (fortunately?). i tend to use bash utils for that, and i 100% do not think telling people to "just use grep / awk / perl and csvcut" is by any means a solution.
Should those things be done in sql? Yes... could this data be sent as SQLite files? Yes... were they endemically sent as csv and nothing could change this? Yes...
Excel is by far the best of “spreadsheet” apps I’ve seen at munging through multi-hundred-mb csv files.