quotes are contained in a field, you need to escape them. Real CSV
uses a backslash, Excel CSV uses another quote (like CF). I'm not
100% sure about newlines inside fields, but I think you can leave them
there without issue.
cheers,
barneyb
On Thu, 26 Aug 2004 16:55:58 -0400, CF Coder2
<[EMAIL PROTECTED]> wrote:
> > CSV will work, and HTML table should too, though I've not checked on
> > '97.
> >
>
> I should have stated that I have Excel 2000, not 1997.
>
> How do you deal with column values that have commas in the data?
> Do you quote each list item or ?
>
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

