How to search for a file that has different naming convention that the row item on file

Guys…Can across complicated scenario at least for me…

Process flow…
Read the Master excel sheet → Pick the Emp Code-> Download the Data from web-> Save as with naming (Project Name+Emp Code+ “SAL”) — till this portion I have done…

Now, I have to upload this document to shared folder link provided on the master excel sheet column B…in that case the bot will loop through the Master excel sheet it will search the same name present on the excel and search that document on the folder …

What logic should I apply in this so that it should search and upload the document matching the Emp Code column present on the master excel sheet though the file name is different on folder
I don’t want to add an additional column on excel using concatenate what I want for bot to check for exact document match either it should create a variable and store the naming convention provided above…
image
image

Kindly help

Hi @ShreyaSharma
Read the Excel file and check the empcode.toString.equals("")

Thanks
Ashwin.S

empcode.toString.equals("") didn’t get you…It will pick the new file name…
12_1_10000 though in excel its 1?