StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
13416248
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-11-16T12:04:00.230
FavoriteCount
0
LastActivityDate
2012-11-17T09:47:33.050
LastEditDate
2017-05-23T12:18:43.740
LastEditorUserId
-1
OwnerUserId
603855
ParentId
13415663
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Start with a skeleton script that traverses a folder tree: <pre><code>Step00.vbs: Option Explicit Dim goFS : Set goFS = CreateObject("Scripting.FileSystemObject") WScript.Quit Main() Function Main() Dim sDir : sDir = "..\test" Dim oWorker : Set oWorker = New cWorker Main = traverseDir(goFS.GetFolder(sDir), oWorker) End Function Class cWorker Public Sub processFile(oFile) WScript.Echo oFile.Path End Sub End Class Function traverseDir(oDir, oWorker) traverseDir = 0 Dim oF For Each oF In oDir.Files oWorker.processFile oF Next For Each oF In oDir.SubFolders traverseDir = traverseDir(oF, oWorker) Next End Function </code></pre> Output: <pre><code>cscript step00.vbs E:\trials\SoTrials\answers\13415663\test\13415663.notes E:\trials\SoTrials\answers\13415663\test\13415663.kpf E:\trials\SoTrials\answers\13415663\test\13415663-UE15.prj E:\trials\SoTrials\answers\13415663\test\vbs\step00.vbs </code></pre> The Main function passes a folder and a worker to the traverseDir function and returns an exit code to be passed to the caller (OS). The traverseDir function sends each file in a directory to the worker's processFile sub, call itself recursively for each subfolder, and returns an error code to the caller (Main/previous instance of itself). The (trivial) worker just echos the file's path. Step01.vbs uses a worker with a hardcoded condition to determine which files to delete: <pre><code>Class cWorker Public Sub processFile(oFile) If "notes" = goFS.GetExtensionName(oFile.Name) Then WScript.Echo "will delete", oFile.Path oFile.Delete End If End Sub End Class </code></pre> output: <pre><code>cscript step01.vbs will delete E:\trials\SoTrials\answers\13415663\test\13415663.notes </code></pre> Based on this proof of concept script you can enhance the traverseDir function (error handling for not accessible folders, ...) and/or the cWorker class (more complex condition, error handling, logging, ...). Update: See <a href="https://stackoverflow.com/a/13429422/603855">this recursive folder access script</a> to get ideas for further enhancements of the skeleton.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POVB Script to Delete files in subfolder
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USEkkehard.Horner
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.