0

I have 1,015 images in a folder and these images is classified into seven categories of medical diagnoses of skin cancer, and the same images are classified in the Excel file by number (the number of each image corresponds to the type of diagnosis of this image). The type of image is labelled as "dx". Clearly, each image has a specific number corresponding to the diagnostic type, my question is How do I search for a group of files by copying their names from the Excel file and then paste them in the search box in Windows at once. In other words i want to take the names of a hundred images from the Excel file then search for them by pasting their names in the search box. Can I do that or do I need a particular tool?

images folder excel file excel file

1

2 Answers 2

2

You will have to add an OR within spaces between the search parameters (filenames)

enter image description here

To create this querie add " OR " in the next column of your file and then just select everything to copy paste it.

enter image description here

7
  • It is difficult to write OR when i need to search of 50 files or 100 files at once Sep 26, 2019 at 7:17
  • 1
    @AhmadSarairah write your search criteria with a formula in Excel, if you have 2016 you should be able to use a function called TEXTJOIN
    – PeterH
    Sep 26, 2019 at 7:21
  • @AhmadSarairah or just write " OR "in the column next to the filename and then select everything for copy paste
    – veritaS
    Sep 26, 2019 at 7:22
  • I need to copy 50 names from the Excel column and paste them into the search box, but the problem only copies one name in the search box and this is my problem Sep 26, 2019 at 7:55
  • 1
    @AhmadSarairah using the image above, in Cell C2 use =TEXTJOIN("OR",TRUE,A1:A10)
    – PeterH
    Sep 26, 2019 at 13:36
1

I suggest the following:

  • Download "Everything" (search-app) https://www.voidtools.com/ (I suggest you download the "portable" version. Just extract the contents to a folder, and run the app. Afterwards you can simply delete the folder.)

  • Then do as veritaS suggested. Create a column in Excel to the right of the filenames. Fill it with "OR". Select the cells of both columns and press "Copy".

  • Now "Paste" into the searchfield of the "Everything"-app.

If you wish to move the files into folders. You can just drag'n'drop or cut+paste the files from the search results in "Everything" to a windows-explorer window.

2
  • In case you don't know: You only need to write "OR" once. Then select the cell. In the bottom right corner of the cell will be a small dot. Left-click and hold on that dot, now drag your mouse down over the empty cells below. Once you let go of the mouse-button, "OR" will be copied into all those cells.
    – elimendo
    Sep 26, 2019 at 11:16
  • I worked the steps as above but when I pasted the names in the search field , then I pressed enter nothing appears Sep 29, 2019 at 8:42

Not the answer you're looking for? Browse other questions tagged .