Showing posts with label Search. Show all posts
Showing posts with label Search. Show all posts

Friday, December 16, 2011

Save Windows 7 Search Results as Text File

I recently had to create a list of over 3000 files that were dispersed amongst 60 folders. In the past, I would have used NirSoft's SysExporter, but unfortunately it does not work with Windows 7.

Fortunately, rummaging around in my internet, I found a simple way to make lists from Windows Searches. Here is a step by step guide.

Select the directory that you want to search:

Click images to enlarge

Enter your search:


Once you have your list, select all results and hold the Shift key and right-click on the list. Select "Copy as path" from the menu:


Now you can paste the results in a text document - here I have pasted the results in Excel (2007):


To get rid of all the path information, choose "Text to Columns" from the Data menu:


Then press the radio button for "Delimited":


And set the back-slash "\" as your delimiting value:


This will make the file name its own column:


And you can throw out all the path information and have a nice clean file list:


Friday, May 27, 2011

How To: Searching Multiple Files In Lightroom

I am going through ten years of archive photos at The New York Botanical Garden Herbarium and creating Adobe Lightroom catalogs in preparation for a massive file type migration.

Catalog of CD Archive

We have over 800,000 images taking up about 27 terabytes of space. Many of the files are duplicates in various formats. There are about 400,000 legacy small derivative files (500GB) in a format that is no longer supported by our web client. While they are duplicates, we will not throw them away, they will simply be taken offline and put on tape. There are also about 300,000 TIFFs which are production masters. As discussed in an earlier post, these files are rarely if ever accessed and there are corresponding RAW archive masters. These TIFFs will also be moved offline on to tape. This will free up close to 8 terabytes.

The challenge I have created for myself, is to have at least one of every image remain on our server, so I am looking for files that do not exist in RAW format (there are about 3000 files - 1% - that were not archived properly). So, how to find 3000 files out of 300,000?

I tried a Windows search of the image server using a semicolon delimited list. Unfortunately, this produced poor results for reasons I can not explain. So then, in my newly minted Lightroom catalog, I tried a filename search "Contains" semicolon delimited list.

Semicolon delimited search

This was a test. I knew those files were in there. So, I tried a Filename "Contains" comma delimited list.

The winner