Read csv file c# with comma separator

Question

I'm trying to read an csv file with the format: name, location Joseph, "street xpto, London"

When I read CSV, I split the file to ",", but when the line has "street xpto, London" (other commas) it doesn't work.

Is there some solution to that? I need to do split ignoring commas when find an " ".

var reader = new StreamReader(File.OpenRead(@"C:\example_File.csv"));

while (!reader.EndOfStream)
{
    var line = reader.ReadLine();
    String[] values = line.Split(',');

    for (int i = 0; i < values.Length; i++)
    {
    }
}

is the address surrounded by quotations as shown? You would be better looking into a csv parsing library though.. — Sayse
– Sayse, Commented Apr 16, 2015 at 14:56

Loofer · Accepted Answer · 2016-03-10 10:05:48Z

4

Don't reinvent the wheel. There are extremely good libraries that will help you do all this. The one I like is CsvHelper available through nuget Install-Package CsvHelper or from the project home page.

edited Mar 10, 2016 at 10:05

answered Apr 16, 2015 at 15:05

Loofer

7,0339 gold badges67 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

PiotrWolkowski · Accepted Answer · 2015-04-16 15:18:17Z

0

Text field parser handles this already

using System;
using Microsoft.VisualBasic.FileIO;

class Program
{
    static void Main()
    {
    using (TextFieldParser parser = new TextFieldParser("C:\\csv.txt"))
    {
        parser.Delimiters = new string[] { "," };
        while (true)
        {
        string[] parts = parser.ReadFields();
        if (parts == null)
        {
            break;
        }
        Console.WriteLine("{0} field(s)", parts.Length);
        }
    }
    }
}

edited Apr 16, 2015 at 15:18

PiotrWolkowski

8,8007 gold badges53 silver badges77 bronze badges

answered Apr 16, 2015 at 15:15

Dom

7164 silver badges11 bronze badges

Collectives™ on Stack Overflow

Read csv file c# with comma separator

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related