I am having trouble getting a text field from a database to display correctly in a csv file.
The ASP.NET application collects information from several database tables and returns it as one csv file. This works fine but there is one field called "Message" which is a text field in SQL Server, people use it to type in messages for deliveries with a certain product. The message field is the only one giving problems, if I replace it with any other field the format is fine.
I think that there must be line breaks (or similar) being inserted in the streamwriter when creating the csv file. How should I prepare the field for input into the file???