![]() ![]() #"Removed Other Columns" = Table. ![]() Source = Folder.Files(paramRootFolderSearch), LenRootFolderSearch = Text.Length(paramRootFolderSearch), Actually I found it was easier to do a dir /s /b > flatfilelist.txt and compare the results. ValueRootFolderSearch = paramRootFolderSearch, You could also execute tree > tree.txt in both folders and then diff both tree.txt files with any file based diff tool (git diff). The output should look like: - My Documents/pictures/selfies/ - 100MB - My Documents/movies/ - 1000MB - My Music/Mozart/ - 300MB. This query provided the data for me to create a pivot table ( >, ), and I was able to identify a few files that I could deleted which cleared up a lot of space in my directory. I'm looking for a way to print (or write to file) the folder tree of my windows PC, including the size of each folder - but not of single files. ![]() I used this as a guide: MSSQLTips: Retrieve file sizes from the file system using Power Query. The script below can be pasted into a Blank Query The only thing you'll need to do is add a parameter named "paramRootFolderSearch" then add your value, such as "C:\Users\bl0040\Dropbox\". But if you are open to using PowerQuery (Excel add-in, versions 2010 ) then you can create some pretty compelling file size analysis. I realize this question asked for file size analysis using CMD line. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |