Yeah, you quote any field that has either quotes or commas in it. If
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]
- Excel Output File CF Coder2
- Re: Excel Output File Barney Boisvert
- Re: Excel Output File CF Coder2
- Re: Excel Output File Barney Boisvert
- Re: Excel Output File Ray Champagne
- Re: Excel Output File Ewok
- Re: Excel Output File Marc Campeau