Loading

C# String Replace , to "," for .csv output

Hitendrasing Sisodiya

I want to replace , with a "," in my .csv string.

For Example:

Change this
1,S0000093,GNL-000099,Aarpee Hygiene Pvt Ltd,H0010AW0101,G1150505010,G1150504070406,14,GNL-005111,,35637153767

to this
1,"S0000093","GNL-000099","Aarpee Hygiene Pvt Ltd","H0010AW010","G1150505010","G1150504070406","14","GNL-005111","","35637153767"

I have been trying the line.Replace("\"","\"\"")+"\""; but it get anything working properly.

Any help would be appreciated....Thanks in Advance..

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Afzaal Ahmad Zeeshan11y ago
Simply use the following code,
```
str.Replace(",", "\",\""); 
```
What you are doing is totally wrong and would not work even with a small change. I have created a fiddle for you, have a look at it. It works. But remember, you are going to pass it in CSV file. Comma would still be found as a comma only, and the output would still be wrong. You need to work around with some CSV libraries; or you can replace with comma with some other text, maybe a |comma| word.