Hi, I'm looking for a way to automatically rename files using a drag and drop process using OS X. My idea is this:
- I have several video files called, i.e.
10025.mov
10026.mov
Also, I always have a master list of each number and its description. The list is an Excel file that I am able to pull from a program pretty quickly, and it provides the number in the A column, and the description in the B column, like this:
10025 DOOR CLOSEUP 10S
10026 DRIVEWAY 101
10027 DRIVEWAY 102
10028 LICENSE PLATE
10029 GARAGE DOOR
What I want to do is drag files like 10025.mov onto this script/droplet, and it would rename it as "10025_door closeup 10s.mov"
My question is, does anyone know how to do this? The script would have to identify "10025" and find that particular row in the Excel document- then rename the file with an underscore, then the description from the B column. If necessary (since I don't have Excel on my Mac) I could also use a .txt file instead of Excel if that makes it easier. Any insight or Applescript ideas would be greatly appreciated. Thanks
- I have several video files called, i.e.
10025.mov
10026.mov
Also, I always have a master list of each number and its description. The list is an Excel file that I am able to pull from a program pretty quickly, and it provides the number in the A column, and the description in the B column, like this:
10025 DOOR CLOSEUP 10S
10026 DRIVEWAY 101
10027 DRIVEWAY 102
10028 LICENSE PLATE
10029 GARAGE DOOR
What I want to do is drag files like 10025.mov onto this script/droplet, and it would rename it as "10025_door closeup 10s.mov"
My question is, does anyone know how to do this? The script would have to identify "10025" and find that particular row in the Excel document- then rename the file with an underscore, then the description from the B column. If necessary (since I don't have Excel on my Mac) I could also use a .txt file instead of Excel if that makes it easier. Any insight or Applescript ideas would be greatly appreciated. Thanks