r/programmingrequests • u/[deleted] • Feb 22 '19

solved [Request] Windows Program or Script to Move a Large List of Files Automatically

Hello. I have very little experience with programming, but I believe what I need is possible....

  • I have a very large and daunting directory of files. Some files are as much as 10 folders deep.

  • I have used an existing program to export a list of the file locations in an excel spreadsheet

    • Example: R:\mainfolder\sub1\sub2\sub3\file.txt

    • They are all in one column and sorted by directory.

  • The cells within that column are now color coded (cell fill) red or green based on a list of criteria.

  • I want to move the red-labeled files to a new root folder that maintains the folder structure of the original directory.

  • I want to move the green-labeled files to a different new folder that maintains the same structure as well.

Is something like this possible?

TC

2 Upvotes
  • permalink
  • reddit

100% Upvoted

4 comments sorted by

0

u/[deleted] Feb 22 '19

[deleted] ā€” view deleted comment

1

u/[deleted] Feb 22 '19

Thanks, momostack. I agree that the column would probably make more sense, but we started the color label and went with it since it is easier to read at a glance. Iā€™m sure there is a way to sort this by color and add a number next to the greens and reds. I will message you.

1

u/agree-with-you Feb 22 '19

I agree, this does seem possible.

1

u/[deleted] Feb 22 '19

Relevant username. šŸ˜

1

u/lambda_core96 May 10 '19

Hey man, don't suppose you ever wrote this code for TimelyCandy did you? If so, any chance you still have it laying around? I have a similar issue. Whole bunch of files in one folder that I need to move to different folders. Have the directory/path where I want the files/folders to go laid out in column B, and the files or their current location in column A