Looping to a specific value in IEnumerable list

Question

I am using CsvHelper library to read through a list of records in a csv file, and would like to know how I can read loop through the list from a specific value or row.

My CSV file data:

Currently my code is as follows:

Currently my code:
int controlid = 0; //This value is read from a file 

using (CsvReader csvread = new CsvReader(inputFilePath))
IEnumerable<dynamic> records = csvread.GetRecords<dynamic>();

for (int i = controlid; i < records.Count(); i++)
{
    // I get "Argument out of bounds" error here
    customerID = records.ElementAt(i);

    console.writeLine(customerID);
    controlID++;
}

Please look at https://stackoverflow.com/a/33295046/169714 and add an `if(yourvar == controlid){ //.. }` in the loop. — JP Hellemons, Dec 20 '18 at 09:05
Repeatedly calling ElementAt() can be very inefficient. Look up Linq's Skip() and SkipWhile() — bommelding, Dec 20 '18 at 09:10
Or materialize the list from the beginning of using `ToList`. — MakePeaceGreatAgain, Dec 20 '18 at 09:12
I don't think the dupe is a good match, here the exception occurs inside a `i < records.Count()` guard. — bommelding, Dec 20 '18 at 09:15
You should be clear about controlid/controlID , are they really different or is that a copy/paste error? — H H, Dec 20 '18 at 23:08

score 0 · Answer 1 · edited Sep 19 '21 at 13:35

0

using (CsvReader csvread = new CsvReader(inputFilePath))
IEnumerable<dynamic> records = csvread.GetRecords<dynamic>();
records.SkipWhile(e => e != controlid).ToList().ForEach(e =>
{
       console.writeLine(e);
}

I hope this will help.

edited Sep 19 '21 at 13:35

marc_s

732,580
175
1,330
1,459

answered Dec 20 '18 at 09:14

Kostarsus

37
5

Thank you, tried this method, but getting a RunTimebinderException Error [!= cannot be applied to operands of type System.Dynamic.ExpandoObject] – edcoder Dec 20 '18 at 10:44
I'm not realy knowing the System.Dynamic.ExpandoObject. Please try e => !e.Equals(controlid) – Kostarsus Dec 20 '18 at 10:48
Typo: IEnumberable → IEnumerable – Cœur Jul 09 '19 at 15:39

Looping to a specific value in IEnumerable list

1 Answers1