Forum Discussion
creyssonbr
5 years agoNew Member
Using regex to extract directory listing information
Hi,
I need to extract the filename and date of modification from prints that I receive.
Is it possbile on to put that info in a table?
I did it manually, but query gets broken when anything there changes.
They look like this:
D:\Temp>dir
Volume in drive D is HDDX
Volume Serial Number is XXXX-XXXX
Directory of D:\Temp
02/28/2021 08:23 PM <DIR> .
02/28/2021 08:23 PM <DIR> ..
02/28/2021 08:22 PM 193 assistant_installer_20210228202253.log
02/28/2021 08:20 PM 0 file1 - Copy (2).txt
02/28/2021 08:20 PM 0 file1 - Copy (3).txt
02/28/2021 08:20 PM 0 file1 - Copy (4).txt
02/28/2021 08:20 PM 0 file1 - Copy (5).txt
02/28/2021 08:20 PM 0 file1 - Copy (6).txt
02/28/2021 08:20 PM 0 file1 - Copy (7).txt
02/28/2021 08:20 PM 0 file1 - Copy (8).txt
02/28/2021 08:20 PM 0 file1 - Copy (9).txt
02/28/2021 08:20 PM 0 file1.txt
02/28/2021 08:20 PM 0 file2.txt
02/28/2021 06:40 PM 0 FXSAPIDebugLogFile.txt
02/28/2021 06:40 PM 50,216 ThrottleStop.sys
13 File(s) 50,409 bytes
2 Dir(s) 225,865,232,384 bytes free