Previous Topic Next Topic

Batch Script : Find Files with Timestamp in Folder

Closed
soumyajit9 Posts 4 Registration date Tuesday April 17, 2018 Status Member Last seen April 18, 2018 - Updated on Apr 17, 2018 at 04:58 PM
soumyajit9 Posts 4 Registration date Tuesday April 17, 2018 Status Member Last seen April 18, 2018 - Apr 18, 2018 at 06:45 PM
Hi Friends,

I am trying to write a batch script that will:
1) Go to a particular Folder/Directory.
2) Find the files which have current date stamp in the filename (TestFile20180417.dat).
3) Generate a log file with the current timestamp filenames found in step2 above (Can be placed either in same directory or different).

Thanks a lot in advance.

Edit: I will be running this on Windows 7 and will set up as a Scheduled Task in Task Scheduler. So I am looking for a bat script only.

2 responses

Answer 1 / 2
Blocked Profile
Apr 17, 2018 at 05:17 PM
Which part are you stuck on? Can you build a folder directory? At least start something, like declare variables or something!

The time stamp of the file will have the actual date and time. Why use the name for your qualification?

soumyajit9 Posts 4 Registration date Tuesday April 17, 2018 Status Member Last seen April 18, 2018
Apr 17, 2018 at 06:19 PM
Right now, I have placed the below script in the destination folder which runs the script to pull out all the files present in that folder, and then write it to a log file.

However, I want to be able to only pull out one file with the current date stamp as of the machine and output it to a log file. The script should be able to find the system date and use the params to find a file with the datestamp.

I am currently using below script:

@echo off
dir %1 /b /o:gn > "%temp%\Listing"
start /w notepad "%temp%\Listing"
del "%temp%\Listing"
exit

How do I only extract the file which has the current date stamp as on the machine ? This is where I am stuck at. How do I define variables for this ?
Blocked Profile
Apr 18, 2018 at 04:19 PM
Well, to start with, you can write directly to the log, without having to call in notepad. Here is an example of that: 

echo log line %A%>>c:\temp\listing\log.log

If Log.log already exist, it will over write it. If you wish to append to the log.log use the ">" instead of the ">>".
soumyajit9 Posts 4 Registration date Tuesday April 17, 2018 Status Member Last seen April 18, 2018
Apr 18, 2018 at 04:52 PM
Thanks a lot for that. But how do I extract only the file which has the datestamp same as the system date ?
For example, from that folder, I wish to only extract and write to log, the file which has date stamp - TESTFILE20180418.dat ?
Blocked Profile
Apr 18, 2018 at 06:13 PM
Ok, do this:

Cut and paste the code below, then see what it produces. Modify your code based on the result. 

for /f %%i in ('dir /b/a-d/od/t:c %yourfoldervariable%\WhatEverFileNameYouWish.*') do set LAST=%%i
echo The Most recently created file is %LAST%>>%LOGFILE%

SET THEWHOLARCHIVE=%thearchivefolder%\%LAST%
echo THE NEWEST ARCHIVE FOLDER IS SET TO %THEWHOLARCHIVE%>>%LOGFILE%


Give that a try!

Have fun!

Similar discussions

get filenames & timestamps batch file
mhel_0414 -
doesntmatter -

11 responses
Batch file for one current date in text file
AMI -
Robert -

22 responses
Script to edit multiple files
Freondude -
New2This -

11 responses
Batch script to delete file older than 30 day
sd6340 -
eie -

31 responses
Dos Command/Batch file to find a folder size
trusp -
Mandarilho -

15 responses
How do I open a folder using batch file
deepty -
naeem -

15 responses