CSV file read, then sort, then use array again

Question

any help on this scenario please.. new to c#.

Summary:

Need to read the contents of csv into array.
Skip first line of array, then sort on column 1 (company)
Then use sorted array (without header if easier) further along in code.

Example csv:

 Company,Item,Vendor
 Comp1,Bulb,BnQ
 Comp2,Plug,Tesco
 Comp1,Kettle,Wickes

This is my attempt but I get the following error when attempting to access sorted[j] and I cant work out a way around this.

Cannot apply indexing with [] to an expression of type 'System.Collections.Generic.IEnumerable

Code:

var csvRows = System.IO.File.ReadAllLines(filename).Skip(1);
var sorted = csvRows.Select(line => new
                {
                    SortKey = Int32.Parse(line.Split(',')[0]),
                    Line = line
                })
                .OrderBy(x => x.SortKey)
                .Select(x => x.Line);

int maxCount = sorted.Count();

for (int j = 0; j < maxCount; j++)
{
 string line1 = sorted[j].ToString();
 var values = line1.Split(',');
...

Pretty sure adding .ToList() will work: .Select(x => x.Line).ToList();, otherwise you can foreach instead of for: foreach (var line in sorted) { var line1 = line.ToString(); ... — Quantic
– Quantic, Commented Mar 3, 2017 at 15:55
@Quantic thanks, I will give this a go and see if it works for me — NewbieRoo
– NewbieRoo, Commented Mar 3, 2017 at 16:00
You should really learn to Google these exception messages. Typing Cannot apply indexing with [] to an expression of type 'System.Collections.Generic.IEnumerable directly into Google tells you how to fix it. — Steve
– Steve, Commented Mar 3, 2017 at 16:25
@DarrenYoung appreciate the advice, albeit condescending. It was the first thing I did, but still failed to find a solution - hence the post. — NewbieRoo
– NewbieRoo, Commented Mar 3, 2017 at 16:34
When I do as @DarrenYoung says I get Cannot apply indexing with __ to an expression of type 'System.Collections.Generic.ICollection<int> in mvc controller and cannot apply indexing with __ to an expression. — Sam Hobbs
– Sam Hobbs, Commented Mar 3, 2017 at 17:22

Roee Kleiner · Accepted Answer · 2017-03-03 16:23:34Z

2

You need to add .ToList() or .ToArray()to the end of the LINQ query, otherwise your sorted variable is IEnumerable and not list or array, so you cant access it with an index.

answered Mar 3, 2017 at 16:23

Roee Kleiner

646 bronze badges

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

Collectives™ on Stack Overflow

CSV file read, then sort, then use array again

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related