Trouble creating clean csv file in unix korn shell when field is a multi-line text format

[dineed]

Hi - I was wondering if anyone has seen this before and what they did
about it:

I'm creating a comma delimited file - myfile.csv containing several
different columns, two of them are plain text: DESCRIPTION and
COMMANDLINE. The COMMANDLINE field can be one line or hundreds (an
embedded script, for example).

If break out the COMMANDLINE column into separate lines (excel cells)
I don't have a problem, but with the look of the data, except that now
in some cases, I'm bumping into the 65,0000+ line limit of Excel.

When I combine the contents of the COMMANDLINE into a single cell, and
try to open it in Excel, I get special characters as the end of each
line of the cell.

Any ideas on how to clean out these extra characters?

Thanks.

[dineed]

Never mind - I figure it out. the problem was not in my code, but in
the way i was manually doing the ftp. It seems that running the ftp
command in "binary" mode allows the new lines embedded in the fields
to display cleanly. I had been running it in "ascii" mode.

thanks.