Locate files in finder from excel spreadsheet and mark with exiftool. In the spreadsheet: Column 1 = filenames and Column 2 = keep/delete.
I dont understand how to include a variable in the spotlight query. Getting messed up by the single quotes and backslash escapes.
I’ll deal with the looping and exiftool (which i do understand) after I’ve nailed this down. Right?
tell application "Microsoft Excel" set excelvariable to value of cell "A10" end tell set folderx to quoted form of POSIX path of (choose folder) set spotlightquery to "kMDItemFSName =" & excelvariable set command to "mdfind -onlyin " & folderx & " " & spotlightquery set founditems to paragraphs of (do shell script command)
Model: iMac 3.2gHz
Browser: Firefox 3.6.13
Operating System: Mac OS X (10.6)