MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2013

Re: SQL output to csv



fixed

I know this is not the right forum to discuss RFCs, but I interpreted that comment to mean - don't expect excel produced CSVs to look like this spec. From experience, excel does not produce CSVs with double quoted fields

Pillai

On Dec 4, 2013, at 3:53 PM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Wed, Dec 4, 2013 at 3:43 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:
On 04-Dec-2013 12:33 -0800, Narayanan Pillai wrote:
RFC compliant CSV file

In years of looking, I never found any such RFC... though I stopped
looking many years ago.

I stopped looking quite some time ago as well, but since Pillai
mentioned it, I decided on a lark to try again. And what do you know,
but Googling for "csv rfc" produces this:

http://tools.ietf.org/html/rfc4180

Amazingly, it's dated October 2005. It does have a "potentially
misleading" comment about Excel (at least, it's awkward to the point
that I don't think native English speakers would interpret it in such
a way that it reflects reality; but honestly, I think the comment is
just plain wrong).

John
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact