malleshg24
10-06-2019, 01:59 PM
Hi Team,
Need help in modifying file name. In a folder I have input files which contain dates in filename.
Ex1 Daily_report_NY - 10-07-2019.xlsx
Ex2 Daily_report_NY - 10-08-2019.xlsx
Ex2 Daily_report_NY - 10-09-2019.xlsx
Expected result after Modifying filename should be numberwise
Daily_report_NY - 10-07-2019.xlsx after Modify it should be 1.xlsx
Daily_report_NY - 10-08-2019.xlsx after Modify it should be 2.xlsx
Daily_report_NY - 10-0*-2019.xlsx after Modify it should be 3.xlsx
Hardly there will be 5-6 files from Monday to Monday.
Please assist how to achieve this Task. Thanks for your help in advance. !!!
Regards,
mg
Need help in modifying file name. In a folder I have input files which contain dates in filename.
Ex1 Daily_report_NY - 10-07-2019.xlsx
Ex2 Daily_report_NY - 10-08-2019.xlsx
Ex2 Daily_report_NY - 10-09-2019.xlsx
Expected result after Modifying filename should be numberwise
Daily_report_NY - 10-07-2019.xlsx after Modify it should be 1.xlsx
Daily_report_NY - 10-08-2019.xlsx after Modify it should be 2.xlsx
Daily_report_NY - 10-0*-2019.xlsx after Modify it should be 3.xlsx
Hardly there will be 5-6 files from Monday to Monday.
Please assist how to achieve this Task. Thanks for your help in advance. !!!
Regards,
mg