Exporting Memo Fields w/Quotes to CSV 1

[cburts]

I use a memo field that sometimes contains quotation marks and I export the report in CSV format. When I open the file in Excel, it parses the field into separate cells, throwing all of my data out of whack. Is there anyway around this? Please help. [sig][/sig]

 

[MalcolmW]

The Excel forum might be a better spot for this question - the problem seems to be in the way Excel converts CSV's to rows, although someone here might have an answer.
Or you could export your data directly to Excel format from Crystal Reports [sig][/sig]

 

[kenhamady]

If you must go to text before Excel you could use Character Separated instead of CSV. This way you get to pick your separator and delimiter characters and you could pick something that is less likely to appear in your memo. You would have to help excel to open the file by telling it what the characters are for separator and delimiter [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]