Question
Extract date from Excel file string
I have file names like this
P_PAUL-QR-20180827183000.xls
Where 20180827183000 indicates 08/27/2018 at 6:30PM
L_PAUL-QQ-20180828140000.xls
Where 20180828140000 indicates 08/28/2018 at 2:00PM
How do I extract the 20180827183000 or the 20180828140000 from the file name string?
