How To Extract All Zip Files At Once

[Trinh Livingston]

InWindows 7, I have a directory of folders which each contain files as their contents. Is there any way to extract all of the contents of each the folders to a separate location other than cutting and pasting the content one folder at a time?

If you want to move the contents of a source directory and all of its sub-directories to a single destination directory (i.e. flatten the folder structure), it's very easy and you don't even need to bother with the command line.

Just go to the top-level source folder (whose contents you want to copy), and in the Windows Explorer search box type * (just a star or asterisk). This will display every file and sub-folder under the source folder. Now just sort by Type to group all files together, select them all, then cut/copy and paste in the destination dir.

i have Seriously Nested Folder Heirarchy Syndrome (SNFHS) sometimes and i would like a tool that will let me manage this condition by extracting all the files from any particular parent folder and all subfolders.

I know this thread is a few years old but I read through it and felt compelled to reply. I had an SMS folder from my iphone that contained over 1,000 pictures. The folder had literally 500 sub folders. It would've taken me hours to sort it. I thought there might have been an application I could get to sort it. I was almost willing to pay for such app but a simple google search brought me here. Your solution worked PERFECTLY and showed me I had no need for any app outside of my Mac's own finder. The fact that the OP of this thread couldn't figure out your instructions and had the temerity to accuse you of giving bad advice is comical. You tell him how to open a file in finder and he thinks "this thread almost trashed my system." LOL You said nothing about trashing anything. Well that's about it. Your advice was extremely helpful and the OP is the one who owes you an apology if any apology was required.

not to sound cranky here but i think it is really bad form to give advice and then assume that someone has run a backup prior to attempting the suggestion. i mean, i am not ungrateful for the help on the list but this is probably a good time to remind everyone of the importance of being scrupulous about verifying that a backup has recently occurred.

As for checking your backup at some point you're going to have to take responsibility for your own actions or, in this case, inactions. If making sure the backup was good is so important now why didn't you do it without having to be reminded?

there is something really sort of confusing about this (i am on ML at the moment) in that the FINDER window that gets opened up just says "searching This Mac" at the top and then it shows "Search: This Mac All My Files" in the top just under the title of the window. i mean, there does not appear to be any way to determine that i am actually searching this one folder that i opened that is on my desktop /except/ by assuming that it was the window that was in fact open when i ran CMD + F.

am i missing something here or do you know what i mean? i mean, if i happened to accidentally click on another open finder window before running CMD + F there would be no way for me to know that i was about to move a bajillion files from the wrong folder. - or god forbid all my documents from THIS MAC or something?

that is an admirably elegant and measured response. Sir, 1000 blessings on your head, I bought an iXpand thumb drive to take some videos and photos off my phone, but the drive has a nested fold structure, with one folder per month, so it's very difficult to double-check that every photo/video is indeed backed up before deleting them, and I didn't even know if there was a way to display them all in one list, like the All Photos folder on an iPhone but by God there is, and what an beautifully simple solution, thanks to you ! Not only that, but it will also be very handy for my OSX Photos app backups, (and old Time Machine backups) since they too have the nested folder structure by default. No doubt that structure has advantages but it has always felt counter-intuitive to me, so I'm overjoyed to have a found an easy way around it. Have a great day Mr Toad !!!!! ?

hi OT. i was trying to reply to make sure i understood what i just did because it was a tad confusing in the UI. is there something totally messed up if you try this with a folder on the desktop or something? i ran CMD + F and then pulled down to documents and i think i just moved all my documents from somewhere /else/ and CMD + Z is not running an undo...

You haven't moved any files yet, have you? Just close that window. Then open the parent folder manually and try again. Be sure the folder name you're searching is highlighted next to This Mac before starting.

with all due respect i seriously suggest not recommending this to others and if you do to advise them to "MAKE SURE THE FOLDER YOU WANT TO UNCOLLAPSE IS LISTED IN FINDER". i say this in part because i have never found this search function to work very well in Mountain Lion and even in this case it is unclear as to what i exactly did.

i /seem/ to have moved a large number of files from my dropbox but i also move my pvm file from the Parallels folder in my Documents folder. additionally there seems to be a decent number of email attachments that got moved.

in all i can't quite tell what i did by attempting this and beyond not doing it again it could be helpful to get a handle on what happened. that said, this find feature in Finder in Mountain Lion has always behaved squirrelly in my opinion so i never use it...

I'm unsure how to do this but I have probably a couple hundred or so files to go through for data and I'm unsure how to easily extract the data from them onto one sheet. Luckily, each sheet only has one tab of data so my hope was to create a process that could take each sheet and put onto a new single sheet with each excel file it's pulling being a tab on the new sheet. I've put a basic format below which I hope will help explain what I'm trying to do. Additionally, If I can only extract sheets from one folder that's fine too. Just need to speed up the process by any means.

Strangely I was getting an error earlier and it would only pull one file but I found a reference online and managed to get it to work although I still hit a row limit on imported data. Thanks for your help

If you are using Power Query, the tab name is not important because you can get the first sheet everytime. The key to Power Query (cloud or non-cloud) is that the columns are named the same and in a consistent format.

So I ran into a problem where it turns out besides each sheet being named differently. They also named each tab in said sheets differently as well so I haven't been able to import everything besides a single sheet. Additionally, each file seems to have on average 70k rows of data and I believe the limit is 100k? Any ideas how to work around this and pull with a filter as well?

In the middle of the night, I receive 4 separate inline html tables of data by email. With Power Automate I turn that data into four separate csv files and save in a folder OneDrive or SharePoint. At the end of this automation, I then use the Power Automate action "Refresh a dataflow".

That dataflow is essentially Power Query (in the cloud) and I take the 4 csv files in that folder, combine them, do other things and save the data in dataverse table. Dataflows lives in Power Apps but is the cloud version of Power Query.

I did not know that was an option. I just figured power automate since I've used it in the past to automate other things and figured it was the easiest way. I'll try it out and see if it works. Thanks

For clarification: Power Query inside or outside of Power Automate does not require your data to already be in tables; that's the really benefit here, mass file processing of range data and your data will come back as a single collection of data. It could be a csv, excel data, or actual table inside excel or in dataverse but regardless it is available downstream in automation.

Regardless of the method you choose to do it exactly as you described you will need a good understanding in power automate desktop or visual basic. Both of these can handle the no tables and changes in the worksheets.

So essentially open a blank workbook and Get Data from folder. Here you can combine all the files from a folder. You can also do this from other folders, etc, etc, etc. and then you can easily combine all excel sheets into a single table of data to use in automation projects.

Now if you need to do this in automation, again ask yourself why you need it, you can get data with dataflows and do this in the cloud. Then when you combine sheets you can save the output in a dataverse table and use in automation.

if you have a folder, full of sub folders, full of files, it would be great if there was a way to extract all the files at once into the main folder. usually if you search * in a folder, the results will be a list of all the files in all the subfolders, but it's not working in dropbox. I have too many subfolders but don't want to extract the documents subfolder by subfolder. happy to hop on a video chat for a demo of what I mean. thank you!

I have a setup with Couchpotato, Sonarr and Transmission. Couchpotato is able to unrar files after completion, but Sonarr doesn't have this function.

I know there is a function in Transmission called "Script to process after torrent finishes".

Here I should be able to select a script that does the unrar for me, but is there any script like this available and how do I install it?

Great! Will it be able to unrar files in different folders?

If I point it to /path/to/downloads/media/ and there are two folders in /media, one named /.tv and one named /.mov

Will it extract the files in these folder automatically?

Setting permissions would be a longer script (which I can provide if you want) and with my setup, changing permissions/owner script has to be run by root or admin priv (could be my settings stopping it but don't care).

3a8082e126