How to export CSV with embedded commas?

[David Thompson]

>I have a chunk of information that holds a paragraph of description. If
>the first sentence says, "We bought apples, bananas, and cherries", the
>commas in that sentence become delimiters and apples, bananas, and
>cherries are separated in the exported text.  I thought I had read that
>info within quotes would be somehow held as a unit; that didn't work for
>me. So when I have NO option  other than CSV, and I MUST export a block
>of text with commas used as punctuation, what do I do?

The quotes have to enclose the entire contents of the field, not just 
the first sentence. When the text file is imported the quotes are 
stripped.

If you choose SaveAs... from the File menu, and check the Text Only 
radio button, a new dialog will appear when you click the Save 
button. You would use that dialog to select the fields you want to 
export, and to choose commas as the delimiter. If the text in a field 
contains delimiters, such as commas, tabs or quotes, then enclosing 
quotes will be added automatically, and any embedded quotes will be 
doubled.

Dave