save to csv problem

I am using this code to save data from richTextBox to .csv file.

richTextBox1.Text = csv.ToString();

string savefileDirectory = Path.GetDirectoryName(opfd.FileName).ToString() + "\\Results\\";

if (!Directory.Exists(savefileDirectory))

Directory.CreateDirectory(savefileDirectory);

//to save the changed files.........................................................

SaveFileDialog sfd = new SaveFileDialog();

sfd.FileName = savefileDirectory + "fileR1" + ".csv";

//File.WriteAllLines(sfd.FileName, richTextBox1.Lines);

But what i am getting is data saved in .csv file separated with commas in a line or row, not separated by cells in a row.

Something like this: 234,456,wer45,22-00-99

I wanted if data could come in separate cells in every row without showing the comma. So I need help if anyone knows where i am going wrong.

Thanks

3 Replies

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

Rajeesh Menoth10y ago
Accepted answer
Hi,

If you want comma separated value ?.Then use Replace in c#

try this..

String str = "234,456,wer45,22-00-99 ";

String Result = str.Replace(","," ");
0
Rajeesh Menoth10y ago
Hi,

Welcome :)
0
Lili R10y ago
Thanks rajesh.. actually my previous code also worked when i when i changed the source file read only to writable.
0