3 ms·
The worst is when you store it as a string, having learned from others' mistakes, but then upon exporting to CSV... Excel kindly strips the leading 0 and you ge
by zaroth 12y ago
The worst is when you store it as a string, having learned from others' mistakes, but then upon exporting to CSV... Excel kindly strips the leading 0 and you get a bug report that your software is screwing up the ZIP codes!
Took a bit of searching before finding this: https://www.webdigi.co.uk/blog/2010/handling-leading-zero-in-csv/ https://www.webdigi.co.uk/blog/2010/handling-leading-zero-in...
- WatchDog 12y agoExcel is the bane of my existence. I give a lot of speeches about how to preserve data precision. However It seems to be largley in vain, as there is often a lot of back and forth when handling data between different groups, even programmers don't seem immune from screwing up a csv file with excel.
- UrMomReadsHN 12y agoOh god office workers love putting everything in Excel. Even when it makes no sense...
- TeMPOraL 12y agoCan't blame them. The only other choice they usually have is some crappy, poorly thought "database system" written by IT people who are poster children of this article. I'm a programmer and I defend use of Excel in the offices - I've actually worked in such an office before and I know that all the alternatives suck more. And I guess that's one of the biggest mistake programmers make - assuming that real-life data will conform to some imaginary, bureaucratic, fixed format. Even schemas ain't fixed in real life. That's why people use Excel.
- mgkimsal 12y agoThe other awesome is taking a screenshot, pasting it in to MS Word, then mailing the docx file. The entire screenshot then ends up being 3 inches across.