I have an Excel document and I hope to count the number of lines between every row that starts with “ID” (string). I have used “Read CSV” activity and then I’m not sure what activity to use.
I’m sure I’ll have to use the count function though (but not very sure of the syntax): datatable.Rows.Where(IndexStart=“ID”).Count
Please advise. Thank you!