Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have files in a folder, in the format below
20201207_05_31_06AM_Report.xls
20201208_13_31_06AM_Report.xls
20201209_17_56_31AM_Report.xls
20201209_22_31_15PM_Report.xls
The first characters are 20201207 in YYYYMMDD format while the latter ones are in HH_MM_SS with AM or PM
How do I load data from .XLS in my script? In this case, it should be 20201209_22_31_15PM_Report.xls as that is the latest.