Create CSV from String Array C#

Question

I want to create a CSV but when a value has comma it gets formatted wrong.

List<string[]> output = new List<string[]>();
output.Add(valuesRow.ToArray());
int length = output.Count;
for (int index = 0; index < length; index++)
{
 stringBuilder.AppendLine(string.Join(delimiter,output[index]));
}

But when output[index] has value with comma its get formatted wrong.

Can you just remove the comma from `output[index]`? – MisterMystery Feb 08 '18 at 21:59 — MisterMystery, Feb 08 '18 at 21:59

score 2 · Accepted Answer · answered Feb 08 '18 at 22:02

2

Change

stringBuilder.AppendLine(string.Join(delimiter,output[index]));

to

stringBuilder.AppendLine(string.Join(delimiter,output[index].Select(x=>"\"" + x + "\"")));

answered Feb 08 '18 at 22:02

Eser

12,031
1
19
32

1

Of course, the next problem is handling fields that have double-quote characters. – Joel Coehoorn Feb 08 '18 at 22:09
@JoelCoehoorn Of course :) `x.Replace("\"","\"\"");` – Eser Feb 08 '18 at 22:09

score 1 · Answer 2 · answered Feb 08 '18 at 22:03

1

You can use CsvHelper to generate your .csv output. You can specify your columns and inject your value by field name.

https://joshclose.github.io/CsvHelper/

answered Feb 08 '18 at 22:03

Babak Naffas

11,988
3
35
49

Create CSV from String Array C#

2 Answers2