How to recognize comma within field when importing CSV file using StreamReader

[xitij9]

Hi,

I am importing a .csv file using StreamReader. I can not use Jet Engine as I cannot install it on client. I am reading it line by line and then split the line with comma and get the array. (Is there any more efficient way then this ?).


using (StreamReader sr = new StreamReader(_fileName))
{
string line;
while ((line = sr.ReadLine()) != null)
{
string[] fields = line.Split(',');
}


I have field like address which itself can contain comma. So I think the split logic can not work. Is there any better way to handle this.

[jimmarq]

If it is a well formated CSV file, there should be some sort of qualifier surrounding any data that contains the delimeter. Otherwise, there's no way to tell where one piece of data ends and another begins.

E.g., in the following example, the quotation marks ("") denote where one data element begins and ends.

first,"second , with a comma",third