3

I am attempting to rename a large batch of files to incorporate the dates in the "Date Modified" column from File Explorer into each filename in YYYYMMDD format. I was able to generate a report from the desired file folder of all the files inside using the following steps:

  1. Click on the Tips and Tricks folder
  2. Hold down the Shift key and right-click the Tips and Tricks folder
  3. Click “Open Command Window Here”
  4. Type dir>filename.txt
  5. Click Enter
  6. Open the Tips and Tricks folder and look for a text file with the filename you created

I then pulled the report into Excel as a delimited text file and manipulated the content so I now have the "last modified" date in one column and the filename in another:

Date Modified | File Name

1/9/2009 | ArcGIS_TT_Projections_Transformations.doc

2/18/2014 | ArcGIS_TT_Re-Projection_WMAS.docx

1/9/2009 | ArcGIS_TT_Set_Selectable_Layers.doc

1/9/2009 | ArcGIS_TT_Spatial_Join.doc

4/21/2010 | ArcGIS_TT_View_CLU_History_Layer.doc

I have only had success using rename scripts like the following:

@echo off
setlocal enableDelayedExpansion
for %%F in ("ArcGIS_TT_Projections_Transformations*.txt") do (
  set "name=%%F"
  ren "!name!" "!name:ArcGIS_TT_Projections_Transformations=ArcGIS_TT_Projections_Transformations_20090109!"
)
pause

But I am trying to avoid having to repeat that process for 61 files. Does anyone out there have a suggestion of a Windows CMD prompt or a simple .txt that I can use to pull in the date modified information into the filename more automatically?

Thanks for your help!

  • Have you looked at adding the command dir /T:W pathtofile to your batch file? windows-commandline.com/get-file-modified-date-time – user5870571 May 13 '16 at 19:02
  • @user5870571, Sorry, I'm a newbie - what is "/T:W"? and where would I incorporate that? – newbie May 13 '16 at 19:14
  • If you want more information read the link I included. The command I provided you will give you the modified date of a file. – user5870571 May 13 '16 at 19:15
  • @user5870571, I read the link, but I am not sure where I would add dir /T:W pathtofile into a rename script. I have all the last modified dates already - I'm just trying to add them into the filename. Please demo in code sample if you can - I really am a newbie. Thanks! – newbie May 13 '16 at 19:31
2

Ok @newbie, here is the code you need to use to iterate the text files, obtain the modified date of each file, copy each file using the modified date as part of the file name, and delete the original files. You were very close, but you were missing a few things.

To get the modify date of a file we can use set "MDate=%%~tF".

To parse the date that is provided by set "MDate=%%~tF" you will need to specify which parts of the value stored by %MDate% you want to use in the output. You can use the command set "ParsedDate=!MDate:~6,4!!MDate:~0,2!!MDate:~3,2!" to convert the output of set "MDate=%%~tF" from MM/DD/YYYY hh:mm to YYYYMMDD.

After that we can copy the files to new files using the value of %ParsedDate% in the filename.

You should see two copies of the files. If you want to delete the original files we just need to run the command for %%F in ("C:\test\*.txt") do ( del %%F ). That will leave you with the renamed text files. To convert the .txt.new to .txt use the command ren "C:\test\*.new" *..

Because we are in a for loop we need to change how we address varables (which based on what you have written so far you already know). We change % to ! for variable names inside a loop. So if you have the variable name example you would reference the variable using !example! inside the loop instead of %example%.

For variables inside the loop to work we also need to add the command setlocal enabledelayedexpansion before the loop.

That should cover everything. Please feel free to upvote or mark the answer as correct if this solves your problem.

The full batch file is provided below.

setlocal enabledelayedexpansion

for %%F in ("C:\test\*.txt") do ( 
    set "MDate=%%~tF"
    set "ParsedDate=!MDate:~6,4!!MDate:~0,2!!MDate:~3,2!"
    copy %%F %%~dpnF_!ParsedDate!%%~xF.new )

for %%F in ("C:\test\*.txt") do ( 
    del %%F )

ren "C:\test\*.new" *.

exit
|improve this answer|||||
  • 1
    You are welcome. Please let me know if you need anything else. – user5870571 May 16 '16 at 15:56
  • is there a way to also display the hour/time (wont work on my machine because of the : ) and put the date before the filename? – Swizzler Feb 17 '19 at 11:47

Not the answer you're looking for? Browse other questions tagged or ask your own question.