Selecting files based on a spreadsheet list

Discussion in 'Mac Basics and Help' started by beepbeepvd, Nov 18, 2013.

  1. beepbeepvd macrumors newbie

    Joined:
    Nov 18, 2013
    #1
    Hi everyone,

    I have a folder containing 44,000 web images, and I have a spreadsheet list of about 2,000 files that I need to drag or duplicate into a new folder.

    Does anyone know of software or an app that would automatically select those 2,000 images so that I don't have to do it individually by hand?

    Thanks!
     
  2. r0k macrumors 68040

    r0k

    Joined:
    Mar 3, 2008
    Location:
    Detroit
    #2
    I find shell scripts to be useful in situations like this. I would export the list of files to a plain text file. I create a folder called newfolder and then in Terminal I would do something like:

    Code:
    for f in 'cat names.txt' 
    do
    cp $f newfolder
    done
    I'm not in front of my Mac so I can't easily check the syntax but this is the basic approach.

    Another approach is to use applescript.
     
  3. beepbeepvd thread starter macrumors newbie

    Joined:
    Nov 18, 2013
    #3
    Thanks for the help! I'm going to give that a try.
     

Share This Page