CSV spec and the failure that is MSDN

Richard Gaskin ambassador at fourthworld.com
Fri Dec 3 16:43:13 EST 2004


Anyone know where I can find the official spec for the CSV formats used 
by Micro$oft Access, Micro$oft Excel, and the the spec used by the rest 
of the world?

All three differ from one another, and according to some Micro$oft has 
changed how CSV is implemented in Excel at least once, maybe twice, so 
it would be good to find historical specs as well.

So far the best I can find is this page:
<http://www.lazy8.nu/doc/exportoptions.en.html#standardspecification>

Nice, but doesn't cover the change, nor Access at all, and if from a 
third party so I have no way to know how current or thorough it is.  At 
least with Micro$oft-published specs I can point customers to the source 
if they have a problem.

Some of the differences include how/whether returns, tabs, commas, and 
quotes are escaped.  For example, some programs output CSV with quotes 
escaped with \q, and others with \", and others with "".  Fun eh?  And 
that's just the beginning.

I've tried looking through MSDN, but everytime I try to use that archaic 
search engine I get more headaches than results.

If any of you know the secret recipe to finding how Microsoft defines 
CSV in its products I'd be much obliged.

--
  Richard Gaskin
  Fourth World Media Corporation
  __________________________________________________
  Rev tools and more: http://www.fourthworld.com/rev


More information about the use-livecode mailing list