|
I work as a volunteer scanning documents and I could really use a program that essentially just lists files in subdirectories so I could dump them in an Excel cell next to the information for each document. I've been using Directory List and Print or something and even the pro version doesn't do what I want, bizarrely, requiring me to use an online tool to remove line breaks, and reformat stuff, remove thumbs.db, etc by hand. Essentially, it just needs to iterate through subdirectories and spit out a text file with a list of files (no paths, just files) separated by semicolons and with each subdirectory on a new line. Ideally it would skip thumbs.db. So something like this directory structure: C:\Blah\1995\Blah - January 1995.jpg C:\Blah\1995\Blah - February 1995.jpg C:\Blah\1995\Blah - March 1995.jpg C:\Blah\1996\Blah - January 1996.jpg C:\Blah\1996\Blah - February 1996.jpg C:\Blah\1996\Blah - March 1996.jpg would output as a text file like this: Blah - January 1995.jpg;Blah - February 1995.jpg;Blah - March 1995.jpg Blah - January 1996.jpg;Blah - February 1996.jpg;Blah - March 1996.jpg Then I could copy all the lines into Excel starting at the appropriate row. Any help or suggestions?
|
# ¿ May 26, 2015 01:57 |
|
|
# ¿ May 17, 2024 19:33 |
|
I'll try them both out tomorrow at work, thanks!
|
# ¿ May 26, 2015 06:46 |
|
It seemed like the Python script posted last page was working perfectly but I've used it a few times recently and it now seems to be ignoring natural order (it's going 1, 10, 11, 12, 2, when I can verify from page order on uploaded materials that it was ordering them perfectly before) and also including thumbs.db for some reason, when I can tell it should be specifically excluding it. Some rear end screwed around on my work PC and updated Python but I rolled back to 2.7 to check if that did anything and it didn't seem to fix it. I realize how bizarre this is, but does anyone have any ideas?
|
# ¿ Oct 9, 2015 18:11 |
|
Sebbe posted:Here's a version that enforces natural sorting: edit: works perfectly! Srebrenica Surprise fucked around with this message at 07:55 on Oct 17, 2015 |
# ¿ Oct 13, 2015 08:08 |