Text export to .csv

[tb]

I am exporting text to a csv file using stringbuilder. (C#)

The problem that is that some text (from the Database originates from multiline textbox) have \r\n in them. Thus opening in Excel is looks terrible. Is there a way to replace \r\n with ALT + \r\n - which would be acceptable for Excel to display properly in a cell ?

Anybody any ideas?

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[jmeckley]

does it have to be csv, could it be xml? are you exporting this data simply to open it in excel? if so check out

http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx

i use this for any project interacting with excel

Jason Meckley
Programmer
Specialty Bakers, Inc.