LINQ query to split data table depending upon the row value

Hi everyone,

I have a excel with two table and both table row count can vary. At the end of the table the row value will be “End Of Records”. I need to split this table based on the “End Of Records” and get the first table as a DT

Can anyone please help me how to do this using LINQ query?

I am tagging @ppr, he is the best person I know who can give you a suggestion or solution.

2 Likes

@kishore.shetty1
with following pattern a split can be implemented:

  • Find Index of Split marks
  • Calculate split start/end dimensions and take split rows with the help of skip, take method

find starter help here:
DT_Slice_ByKeyWord-1Col_ToTableList.xaml (11.1 KB)

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.