Hello all,
I have a folder that contains few excel files which are named with dates date,month,year and time(hhmm)
for example file name- Test_01022020_0530 (here-01 stands for day,02 stands for month,2020 stands for year,05 is hours and 30 is minutes).
Lets say I have 4 excel files of the following name pattern
Test_02012020_0120
Test_03012020_0230
Test_01022020_0530
Test_07012020_0400
In the above four files, how do I extract the file which has the latest date attached to the file name.
It would be really great if anyone could help me out with the issue.
Regards.
Parvathy sunil.
I have a folder that contains few excel files which are named with dates date,month,year and time(hhmm)
for example file name- Test_01022020_0530 (here-01 stands for day,02 stands for month,2020 stands for year,05 is hours and 30 is minutes).
Lets say I have 4 excel files of the following name pattern
Test_02012020_0120
Test_03012020_0230
Test_01022020_0530
Test_07012020_0400
In the above four files, how do I extract the file which has the latest date attached to the file name.
It would be really great if anyone could help me out with the issue.
Regards.
Parvathy sunil.