Suggestions? Text edit, Excel, Automator or none of them?
Suggestions? Text edit, Excel, Automator or none of them?
- Subject: Suggestions? Text edit, Excel, Automator or none of them?
- From: Nellyann Rosario <email@hidden>
- Date: Mon, 27 Apr 2009 14:11:11 -0400
- Notification: email@hidden
- Thread-topic: Suggestions? Text edit, Excel, Automator or none of them?
Title: Suggestions? Text edit, Excel, Automator or none of them?
Hello All,
- I have an Excel document with a list of 3 letter code file names.
- Based on that list I need to match the 3 letter code with the physical file .jpg in the server & delete them. One obstacle I have is that the file names in the server do not match exactly with the contents of the Excel document.
For example:
Excel document
ABC
BBD
MMN
GHY
JKO
Server File name
II_ABC1.jpg
II_ABC2.jpg
II_ABC3.jpg
II_ BBD1.jpg
II_ BBD2.jpg
II_ BBD3.jpg
II_ BBD4.jpg
II_ MMN1.jpg
II_ MMN2.jpg
II_GHY1.jpg
II_GHY2.jpg
II_GHY3.jpg
II_GHY4.jpg
II_GHY5.jpg
II_ JKO.jpg
I don’t know if is it better to copy the contents of the Excel paste it into Text Edit or Automator. That way I’ll avoid using Excel. Can Automator can do this or do I need to use applescript. I’m still learning applescript which I find it very difficult to learn. Any suggestions?
Nellbern
_____________________________________________________________________________
Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com
_____________________________________________________________________________
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden