Reading only specific columns from csv file c#

Question

I'm trying to save the values of a specific column from a csv file. I want to take the largest number from this column and keep it in a variable. I'm trying this code, but the problem is that there is a comma in some fields and I can't get the correct values.

var columnQuery =  
        from line in strs  
        let elements = line.Split(',')  
        select Convert.ToInt32(elements[12]);  

var results = columnQuery.ToList();  

int max = results.Max();

Maybe you should use a csv parser. – aloisdg Sep 16 '21 at 14:36 — aloisdg, Sep 16 '21 at 14:36

score 1 · Answer 1 · answered Sep 16 '21 at 14:37

there is a comma in some fields

Then you obviously can't use a naive split like that. It's not hard to parse the line yourself, keeping track of quotes (which are required by the csv format for fields that contain commas), but it's much easier to just import a csv parser nuget and use that.

Reading only specific columns from csv file c#

1 Answers1