Solved

Delete Folder and its contents in a batch file

Posted on 2016-08-30
12
95 Views
Last Modified: 2016-09-04
I have files that are backed up in folders with date and time stamp. I need to delete the folders that have date and timestamp that are older then 30 days. I also want to delete the contents in those folders.

Example Folder Name Test_20160630, Test_20160730

Can someone please help.

Thanks
0
Comment
Question by:Vicki05
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 16

Expert Comment

by:FOX
ID: 41776321
0
 
LVL 54

Expert Comment

by:Bill Prew
ID: 41776323
Here is a BAT script that will do this task.  Change the SET near the top to indicate the base folder where the folders you want to remove exist.

Currently the script is set to only display the folders that would be deleted, and their age.  If you like the results and it looks like that would be right, remove the word ECHO on the RD line, and run again.  It will delete all the folders then though, so test carefully first.

It assumes all folders in the base folder will have YYYYMMDD as the rightmost 8 characters.  It may not work properly is that assumption is not true.

@echo off
setlocal EnableDelayedExpansion

REM Define base for folder, and days to keep old folders
set BaseDir=c:\temp
set DaysToKeep=30

REM Get current date in YYYYMMDD format, convert to julian
set Today=
for /f "tokens=* skip=1" %%A in ('wmic os get LocalDateTime') do (
  if not defined LocalDateTime (
    set LocalDateTime=%%A
    set Today=!LocalDateTime:~0,8!
    call :jDate jToday !Today!
  )
)

REM Process all files, delete if too old
for /f "tokens=*" %%A in ('dir /ad /b "%BaseDir%\*"') do (
  set DirName=%%~nA
  call :jDate jDirDate !DirName:~-8!
  set /A DirAge = !jToday! - !jDirDate!
  if !DirAge! GTR %DaysToKeep% (
    echo Removing Dir:[%BaseDir%\%%~A], Age:[!DirAge! days]
    ECHO rd /s /q "%BaseDir%\%%~A"
  )
)

REM Done
exit /b

REM Subroutine to calculate julian date from (YYYYMMDD) date
:jDate [return-variable] [date-string]
  set DateStr=%~2
  set yy=%DateStr:~0,4%
  set /A mm=1%DateStr:~4,2%-100
  set /A dd=1%DateStr:~6,2%-100
  set /a "yy=10000%yy% %%10000,mm=100%mm% %% 100,dd=100%dd% %% 100"
  set /a %~1=dd-32075+1461*(yy+4800+(mm-14)/12)/4+367*(mm-2-(mm-14)/12*12)/12-3*((yy+4900+(mm-14)/12)/100)/4
  exit /b

Open in new window

~bp
0
 

Author Comment

by:Vicki05
ID: 41776432
Hi Bill,

The batch file deleted folder that did not have a date time stamp on it which I did not want. The folder was created today. The folders that I want deleted are labeled as Test_20160829-121525 for example. The date and time changes. Every time the system is rebooted. It moves the test folder with date and time stamp. It creates a new folder Test and creates a new backup.

I would like the batch file to only look for files that have a date and time stamp and delete folds including its content Test_20160829-121525, Test_20160629-111543
untitled.bmp
untitled2.bmp
untitled3.bmp
untitled4.bmp
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:Vicki05
ID: 41776433
Forefiles does not work on xp as it is not resident in this version of Windows XP
0
 
LVL 54

Accepted Solution

by:
Bill Prew earned 500 total points
ID: 41776465
Okay, I have adjusted for the new folder naming format you have mentioned.  It will only look for folders matching the pattern *_????????-?????? which should narrow it down to just the ones you want.  It doesn't test that the date and time fields are indeed date and time fields, but I don't think that will be needed with this additional check (it would be a bit hard to implement in a BAT script, not impossible, but a bit more work).  Test this and see how it goes.

@echo off
setlocal EnableDelayedExpansion

REM Define base for folder, and days to keep old folders
set BaseDir=c:\temp
set DaysToKeep=30

REM Get current date in YYYYMMDD format, convert to julian
set Today=
for /f "tokens=* skip=1" %%A in ('wmic os get LocalDateTime') do (
  if not defined LocalDateTime (
    set LocalDateTime=%%A
    set Today=!LocalDateTime:~0,8!
    call :jDate jToday !Today!
  )
)

REM Process all files, delete if too old
for /f "tokens=*" %%A in ('dir /ad /b "%BaseDir%\*_????????-??????"') do (
  set DirName=%%~nA
  call :jDate jDirDate !DirName:~-15,8!
  set /A DirAge = !jToday! - !jDirDate!
  if !DirAge! GTR %DaysToKeep% (
    echo Removing Dir:[%BaseDir%\%%~A], Age:[!DirAge! days]
    ECHO rd /s /q "%BaseDir%\%%~A"
  )
)

REM Done
exit /b

REM Subroutine to calculate julian date from (YYYYMMDD) date
:jDate [return-variable] [date-string]
  set DateStr=%~2
  set yy=%DateStr:~0,4%
  set /A mm=1%DateStr:~4,2%-100
  set /A dd=1%DateStr:~6,2%-100
  set /a "yy=10000%yy% %%10000,mm=100%mm% %% 100,dd=100%dd% %% 100"
  set /a %~1=dd-32075+1461*(yy+4800+(mm-14)/12)/4+367*(mm-2-(mm-14)/12*12)/12-3*((yy+4900+(mm-14)/12)/100)/4
  exit /b

Open in new window

~bp
0
 

Author Comment

by:Vicki05
ID: 41776552
Hi Bill,

The above batch files seems to work. Quick question. If I want to insert this part in another batch file. I do I prevent it from exiting?
0
 
LVL 54

Expert Comment

by:Bill Prew
ID: 41776601
These statements are where my script exits and stops executing.

REM Done
exit /b

Open in new window

These are needed because there is a subroutine that follows that, and without the EXIT /B the script would just step into the subroutine as if it was the main code body.

You can add the main logic of my script in yours as needed, and place the subroutine JDATE after all the merged code, witht he EXIT /B right before it.

~bp
0
 

Author Comment

by:Vicki05
ID: 41782126
Hi Bill,

Thanks for the help. I have had times where the folder does not get deleted. I have to reboot then run the batch file again. Do you know what would cause this?
0
 
LVL 54

Expert Comment

by:Bill Prew
ID: 41783316
When the directory isn't deleted, do you get the "Removing Dir:" message?

My initial guess would be that another program has that folder in use, so it can't be deleted.

~bp
0
 

Author Comment

by:Vicki05
ID: 41783364
I do not get any message, it just not delete.
0
 
LVL 54

Expert Comment

by:Bill Prew
ID: 41784131
I don't see any reason in the code why it would skip folder that match the pattern and date criteria.  You will have to look for folder usage by other programs, or user permission issues, etc.

~bp
0
 

Author Closing Comment

by:Vicki05
ID: 41784218
Thanks for your help. I really appreciate it. I think the folder might have been open as you said.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Can I legally transfer my OEM version of Windows to another PC?  (AKA - Can I put a new systemboard in my OEM PC?) Few of us are both IT and legal experts but we all have our own views of Microsoft's licensing rules and how they apply.  There are…
We have adopted the strategy to use Computers in Student Labs as the bulletin boards. The same target can be achieved by using a Login Notice feature in Group policy but it’s not as attractive as graphical wallpapers with message which grabs the att…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question