How to export CSV with embedded commas?

[Ron Southwick]

> 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?

When I export from Pan 4.02 (Win) using the SaveAs command and choosing
comma output, the data from any cell with commas in it is automatically
encased in quotes. You don't have to add the quotation marks first. (When I
made a field that was already in quotation marks, the data was exported with
double quotation marks ""2, 3"".)

This type of output is similar to what I have seen from Excel when I save a
worksheet as CSV.

I can't speak for the wizard's output.

Ron