Using LINQ for CSV data

Question

My code works great, as long as there aren't any commas in the data.

IEnumerable<Account> AccountItems = from line in File.ReadAllLines(filePath).Skip(1)
                let columns = line.Split(',')
                select new Account
                {
                    AccountName = columns[0],
                    BKAccountID = columns[1],
                    Brand = columns[2],
                    FirstOE = columns[3],
                    LastOE = columns[4]
                };

But the output includes data with commas, and wraps the data in double quotes when there is a comma in the data. I'm not sure if I can still use LINQ to do this.

Acme Health Care,{C2F9A7DD-0000-0000-0000-8B06859016AD},"Data With, LLC",2/4/2013,2/18/2013

Regex here would get very complex very quickly. It's better to use the .NET libraries to handle this. — Matthew Shea
– Matthew Shea, Commented Feb 19, 2013 at 19:58

Community · Accepted Answer · 2017-05-23 10:29:15Z

7

Take a look at this question: Reading CSV files using C#

TextFieldParser parser = new TextFieldParser(@"c:\temp\test.csv");
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(",");
while (!parser.EndOfData) 
{
    //Processing row
    string[] fields = parser.ReadFields();
    foreach (string field in fields) 
    {
        //TODO: Process field
    }
}
parser.Close();

No need to reinvent the wheel when .NET can hold your hand.

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Feb 19, 2013 at 19:57

Matthew Shea

5675 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Using LINQ for CSV data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related