RE: [Pythoncard-users] CSV for PythonCard

[Kevin A. <al...@se...>]

> From: Magnus Lie Hetland

> > I suspect the docstring is a killer:
> >
> >     Generalized to be usable for any delimiter but \n.
> >
> > Many tools can generate CSV files with fields containing newlines.
>
> Really? And what do they use as record separator?

The newline is still a record separator except when it occurs inside quotes.
Pretty much all Microsoft products support this import/export style and many
other apps as well. This allows multi-line data to still be handled by CSV.

> The CSV standard is pretty clear, IIRC: Lines are separated by
> newlines (possibly cr etc.), and fields by commas. Fields
> _containing_ commas must be enclosed by quotes, and any literal
> quotes must be doubled.

Where is the CSV standard documented? That would be useful to have a link
to.

ka