Escape special characters while loading into csv using c#

Asked Jun 18 '18 at 20:47

Active Jun 19 '18 at 06:34

Viewed 371 times

I have a c# application which exports the data from SQL server to CSV. During one such export the data from the table is split into multiple columns due to the presence of certain special characters.

How can I load the data without losing the special characters and without splitting the column data into several columns?

Below is the code sample that is not working fine.

sw.Write( string.Format("\""+column.ToString()+"\""));

where column value is:

Need to add "ABCD, LMSW @ 123-456-789" and J Yu, PhD @ 123-456-789" to OFFICE INFORMATION box on the right side of the web page: https://xyz.abc.yz.edu/

edited Jun 19 '18 at 06:34

James Z

12,209
10
24
44

asked Jun 18 '18 at 20:47

user8940430

Just use a CSV parsing library. They have already solved this problem better than you will. – maccettura Jun 18 '18 at 20:49
could you give me an example please – user8940430 Jun 18 '18 at 21:01
Just google C# CSV parsing libraries – maccettura Jun 18 '18 at 21:05
Possible duplicate of [Parsing CSV files](https://stackoverflow.com/questions/2081418/). – Dour High Arch Jun 18 '18 at 21:22
Guys , I am trying to load the data into the csv from SQL Server table using the C# application. The links that has been provided as duplicate are the other way around – user8940430 Jun 18 '18 at 21:47
The libraries mentioned can also create CSV files from SQL data using a C# application. – Dour High Arch Jun 19 '18 at 00:46

Escape special characters while loading into csv using c#

0 Answers0