I have an excel file with the name format “20200410_ABC_IU-Investors.xls”. Here, the highlighted part is dynamic and shows the date on which the file was downloaded. I want to rename the file completely to something like “ABCBuyers.xls”.
I have tried the rename activity but it stops working once the date changes.
I would really appreciate some help. Thank you.