I certainly wouldn't be one to say that I consider m$ *ANYTHING* to be "where it's at" standard wise, (I guess we can let them have the things that they own (like RTF) and I draw short of saying the things that they "invented" because most of us have read histories of where various m$ branded technologies originated!)

Unfortunately there is no "official standard" for CSV, which can be a major borker - maybe the different variants should be categorised and numbered like CSV1, CSV2, CSV3 etc so it could be agreed upon as to which variant was being used or referred to... :o)

Some kind people are (after MANY years of its being around, and at the point where lots of people say it's on the way out (being replaced by XML) trying to fix this problem by defining it...

I certainly can't speak for all platforms or environments, but one very common format follows the rules that these pages document:

That was what I was referring to.

In this case Excel behaves according to those rules, and is thus an easy tool to use to show how CSV data (according to those rules) should be preserved when saved.

In reply to Re^4: parse_csv (Cookbook) by serf
in thread parse_csv (Cookbook) by powerman

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.