3 ms·
And then you get a business analyst at your client going "I just hit export in our internal tool, what's this delimiter that you're asking me about in the uploa
by Macha 3y ago
And then you get a business analyst at your client going "I just hit export in our internal tool, what's this delimiter that you're asking me about in the upload form? Google Sheets doesn't ask me to tell them that"
- prepend 3y agoAnd how do you fix the “some analyst” problem? Is there a better format that reduces this problem?
- SAI_Peregrinus 3y agoJSON? RON? Protobuf? Cap'n'Proto? Anything with more types than "string" which is all CSV has, and with an unambiguous data encoding. Preferably also a way to transmit the schema, since all of these formats (including CSV) have a schema but don't necessarily include it in the output. About half the problems with CSV are due to encoding ambiguities, the other half are due to schema mismatches.