Sign in to follow this  
Followers 0
13lack13lade

delete all .xls , xlsx , doc files in folders & subdirectories

4 posts in this topic

#1 ·  Posted (edited)

Hi All,

I have a bunch of folders within folders within folders within folders... 

Is there a way i could list the main directory without the subdirectories and have a script that goes into every folder and sub folder and deletes the files that end in certain formats? - Or even happy for it to delete all files in all folders if thats easier.. 

how easy would this be to achieve? i literately have ALOT of folders within folders that i need to clear so they are just empty shells..

 

Any help would be appreciated.

Edited by 13lack13lade

Share this post


Link to post
Share on other sites



Nevermind - solved this using cmd prompt... in the main directory - erase /s /q *.format

however i wonder if there is a way to get a list of filepaths including all the subfolders at all? because i deleted everything i have 1 folder within a few folders that i need to move data back to however there is hundreds.. cant think of a way to copy the files over quickly..

Share this post


Link to post
Share on other sites

13lack13lade,

 

i wonder if there is a way to get a list of filepaths including all the subfolders

_FileListToArrayRec. :)

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

 Try this:

#include <Constants.au3>
#include <File.au3>
#include <Array.au3> ; Required for _ArrayDisplay only.

Example(@ScriptDir)

Func Example($sFilePath, $sFilter = "*.*")
   If Not StringInStr(FileGetAttrib($sFilePath), "D") Then Return SetError(1, 0, 0)

   $sFilePath = StringRegExpReplace($sFilePath, "[\\/]+\z", "") & "\"

   Local $iPID = Run(@ComSpec & ' /C DIR "' & $sFilePath & $sFilter & '" /B /A-D /S', $sFilePath, @SW_HIDE, $STDOUT_CHILD)

   ProcessWaitClose($iPID)

   Local $sOutput = StdoutRead($iPID)

   Local $aArray = StringSplit(StringTrimRight(StringStripCR($sOutput), StringLen(@CRLF)), @CRLF)
   If @error Then
      ConsoleWriteError("Error: " & @error & @CRLF)
   Else
      Local $avArray[0]
      For $i = 1 To $aArray[0]
         Local $sDrive = "", $sDir = "", $sFilename = "", $sExtension = ""
         Local $aPathSplit = _PathSplit($aArray[$i], $sDrive, $sDir, $sFilename, $sExtension)
         Select
         Case $sExtension = ".xls"
            _ArrayAdd($avArray, $aArray[$i])
         Case $sExtension = ".xlsx"
            _ArrayAdd($avArray, $aArray[$i])
         Case $sExtension = ".doc"
            _ArrayAdd($avArray, $aArray[$i])
         EndSelect
      Next
      _ArrayDisplay($avArray)
      For $j = 0 To UBound($avArray) - 1
         FileDelete($avArray[$j])
      Next
   EndIf
EndFunc

I experienced something different from the usual command prompt. ;)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0