I am new to UiPath. I am trying to extract data from unstructured excel file (the data in excel will be shifted every time the file is created). The only unique condition which i can use is the file name (which contains the month). I have an requirement to extract the data for that month from excel based on the file name.
In file name contains date like "05/05/2020.xlsx. The data in excel contains “May-20”. Is there a way i can achieve this in UiPath? After identifying the data i need to create a new excel file for May-20.