I have a query related to splitting large excel file.
There is one excel sheet with approx 1000 rows, I need to split this excel sheet(4 columns) and write to data table based on following scenarios:
- There are 4-5 occurrences of keywords “id8” and “profile.c” in column0
- From 1st occurrence of “id8” to first occurence of “profile.c”, I need one data table.
- From second occurrence of “id8” to second occurence of “profile.c”, I need second data table.
- Needs to go on until no “profile.c” keyword is found.
Thanx in advance