• Jeff Moden - Wednesday, June 28, 2017 7:21 AM

    Sergiy - Tuesday, June 27, 2017 10:42 PM

    Jeff Moden - Tuesday, June 27, 2017 5:54 PM

    It actually is in my list.  Even though it's a bit of a stretch, I included "True CSV" in my wish list which should also take care of the abominations that Excel produces.

    OK, I was not sure about the definition of "true CSV".
    Does it include line breaks within quoted values?

    Yes.  And tabs, commas, double pipes, doubled quotes to escape embedded quotes, etc, etc.  But, to your point, since MS has been getting it wrong for so long, they might not know what the definition of "True CSV" is and probably should have explicitly mentioned the "Comedy Separated Values" that their products seem to exude.

    Well, MS Excel reads "true CSV" files correctly.
    At least older versions of it. Latest versions are so bad in so many ways that I avoid them by all means.

    So, somebody in MS must know how to read CSV files correctly.
    Or  - knew at some point in the past.
    But the source code of Excel97 must be available somewhere for the new generatiuon of geniuses to copy-paste.

    _____________
    Code for TallyGenerator