News for hackers. Stuff that matters.
Re:A straightforward way to extend CSV with metadata by awild on Thursday August 19, 2021 @01:23PM (#28236664)
Excel will strip leading zeros of your data, even when you're escaping it, it will also assume that that single cell of a Column of dot-separated floats is in fact a date. Excel is in fact so good at detecting formats that even if you construct an xls fill it with ids which partially start with zeros, properly mark them as strings, it will still nag you at every single cell of your file that there is something fishy about the file.
Re:A straightforward way to extend CSV with metadata by pbreit on Thursday August 19, 2021 @04:50PM (#28239209)
The stripping of leading zeroes is dreadful when working with zip codes and SSNs.