It's a family of formats, and it's not even a well-specified family of formats.Īt least in semi-technical circles, I've had some success in using this to push back against CSV suggestions and get them to use better things. "Given how badly common tools mangle unambiguously correct CSV data, how many variations there are which make “unambiguously correct CSV data” a somewhat small proportion of what is out there, and how many tools not only expect but require mis-formatted data and/or output it, it is scary how much the format is relied upon in major industries." Given how badly common tools mangle unambiguously correct CSV data, how many variations there are which make “unambiguously correct CSV data” a somewhat small proportion of what is out there, and how many tools not only expect but require mis-formatted data and/or output it, it is scary how much the format is relied upon in major industries.
(We could of course output Excel files directly, but some of them can't download office documents from web apps because of security policy at their end.) Try explaining to a client that we have formatted it correctly and Excel is reading it wrong…
MODERN CSV SOFTWARE
We've had bugs raised against our software because the clients use meeting titles like 1-2-1 for supervisory reviews which when extracted for reporting and opened in Excel (they love to dump data into Excel no matter what report functions you include directly in the application) get interpreted as a date even when output as a quoted string in the CSV file.
0 kommentar(er)
