2 ms·
Problem is not with CSV, problem is with people. People want to read and interpret arbitrary CSV ... well you cannot read and interpret any format that is arbi
by ozim 5y ago
Problem is not with CSV, problem is with people.
People want to read and interpret arbitrary CSV ... well you cannot read and interpret any format that is arbitrary.
*As a consultant, I’ve written more than one internal system that attempts to reconstruct the metadata of a CSV of unknown provenance using a combination of heuristics and brute force. In short, CSV is a scourge that has followed me throughout my career.*
Ideally this should not happen because you should talk with party that you agree on common format. Someone that would explain what each field means and what should it contain, or at least some documentation for the file, not that it just is a CSV. But of course it always is more complicated than that.
Garbage in - Garbage out, even in other formats you still can have the same problem.