I need to select a particular range from either an excel file. I have uploaded a sample excel sheet below.
So, what has to happen is, from “Provider: ABC” to the line before the next provider, the whole content has to be selected and put into a list.
I tried using regex but the whole data is getting selected. I’m not able to figure out how to separate the data. Also tried using read cell activity and Contains function to find the “Provider:” keyword, but cant figure out how to select only till the line before the next “Provider:” line.
Could someone help me out?
Can you upload the excel file you want and what difficulty you are facing and what all you tried?
Hi @Amrita_Narayan ,
Please try Filter Data Table Activity & refer the given link https://docs.uipath.com/activities/docs/filter-data-table