LINQ question with string split and arrays in csv files

Question

Given the code below:

            var query = from line in ClientCount()
                    let aLine = line.Split(",")
                    where aLine.GetValue(1) != 0
                    select aLine;

To query a csv file, will aLine.GetValue(1) get the 1st line (after 0) in the .csv file, or 1st string, eg:

abc, def

And therefore get def? I want to get def, but then I also want to pick up, title2 above that in a file like so:

title, title2

abc, def

How can I do this?

BTW I know there is LINQ To CSV for this but I am doing this myself for the practise.

Thanks

Payton Byrd · Accepted Answer · 2010-03-05 18:40:48Z

3

So, if I read this correctly you want to get the pair "title2","def"; or otherwise put, you want to get the values of column1. The only change you need to your LINQ is as follows:

var query = from line in ClientCount()
    let aLine = line.Split(new[] { ',' })
    where aLine.GetValue(1) != "0"
    select aLine.GetValue(1);

This would exclude rows where the value of the second column is "0", which is what I'm assuming you were attempting to do. This code compiles and runs and gives an IEnumerable with values of "def" and "title2" for the set you specified.

answered Mar 5, 2010 at 18:40

Payton Byrd

9861 gold badge12 silver badges27 bronze badges

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

2 Comments

Joel Mueller Over a year ago

I would have done line.Split(',') and aLine[1]. Less typing is less typing, and the added characters don't provide any benefits in functionality or legibility.

Payton Byrd Over a year ago

I agree, I just didn't want to get too far from the original code.

Marc Gravell · Accepted Answer · 2010-03-05 19:29:16Z

1

While practice is all well and good, CSV is actually a lot more complex than the name suggests - you have quoted/unquoted, multi-line, and the horrible issue where in some areas the "c" becomes a period (".").

I strongly recommend you use something pre-rolled, such as CsvReader.

(Fortunately TSV isn't usually nearly so nasty)

answered Mar 5, 2010 at 19:29

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Collectives™ on Stack Overflow

LINQ question with string split and arrays in csv files

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related