Reading CSV with comma placed within double quotes?

Ekrem Tapan

11y12.7k.NET

Hi all,

I was able to parse and import .CSV file into database, but is having problem parsing .csv file that have comma contained within double quotes. For example,

"XX","XX XX","04011","XX XX XX","XX","XX,XX","XX","XX","XX","20141003 18:54","20141003 20:18","20141003 23:18"

When I parse the above line, "XX,XX" got insert to another column due to the comma in it.

What do I need to do to parse that as a single field for everything that contained within quotes? I'm working on a C# website by the way.

Thank you very much.

4 Replies

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

Jignesh Trivedi11y ago
Hi,
Please refer
http://www.codeproject.com/Articles/415732/Reading-and-Writing-CSV-Files-in-Csharp
hope this will help you.
0
Jean-Claude Colette11y ago
The readline is the input.

string readline = "\"XX\",\"XX XX\",\"04011\",\"XX XX XX\",\"XX\",\"XX,XX\",\"XX\",\"XX\",\"XX\",\"20141003 18:54\",\"20141003 20:18\",\"20141003 23:18\"";
string output;
output = readline.Replace("\",\"", "\"~\"");
string[] cuted = output.Split('~');
output = "";
for (int i = 0; i < cuted.Length; i++) output += " #" + i + "=" + cuted[i];
Debug.WriteLine(output);

The result
#0="XX" #1="XX XX" #2="04011" #3="XX XX XX" #4="XX" #5="XX,XX" #6="XX" #7="XX" #8="XX" #9="20141003 18:54" #10="20141003 20:18" #11="20141003 23:18"

0
Ekrem Tapan11y ago
hi Jean-Claude Colette.,

thanks for explain but, did u have any sample code for your solution ?
0
Jean-Claude Colette11y ago
Hi All,
If the character ~ is not used between the double quote, you can replace the sequence "," by "~"
and split using the delimiter ~
0