Reply to thread

Message

<blockquote data-quote="MacGrunt" data-source="post: 1392712" data-attributes="member: 210105">G'day againSorry, I missed the bit about how you don't have Excel.OK, if you're able to export the list as a .csv (comma delimited) file then you could do something like this :[CODE]set mgOriginalNames to {}set mgNewNames to {}tell application &quot;Finder&quot;&nbsp; &nbsp; set mgTheList to &quot;Colon:Delimited:Path:ToYour:ListFile.csv&quot; as alias&nbsp; &nbsp; set mgFolderPath to &quot;Colon:Delimited:Path:ToYour:Folder:&quot; as aliasend tellopen for access mgTheListset mgList to (read mgTheList)close access mgTheListtell application &quot;Finder&quot;&nbsp; &nbsp; -- split original list into two lists&nbsp; &nbsp; set text item delimiters of AppleScript to &quot;,&quot;&nbsp; &nbsp; repeat with x from 1 to count paragraphs of mgList&nbsp; &nbsp; &nbsp; &nbsp; set end of mgOriginalNames to text item 1 of paragraph x of mgList&nbsp; &nbsp; &nbsp; &nbsp; set end of mgNewNames to text item 2 of paragraph x of mgList&nbsp; &nbsp; end repeat&nbsp; &nbsp; set text item delimiters of AppleScript to &quot;&quot;&nbsp; &nbsp; -- get the folder items&nbsp; &nbsp; tell application &quot;Finder&quot;&nbsp; &nbsp; &nbsp; &nbsp; set mgItems to items of (mgFolderPath as alias)&nbsp; &nbsp; end tell&nbsp; &nbsp; -- check name and rename if match is found&nbsp; &nbsp; repeat with mgItem in mgItems&nbsp; &nbsp; &nbsp; &nbsp; set mgName to name of mgItem&nbsp; &nbsp; &nbsp; &nbsp; set mgExt to name extension of mgItem&nbsp; &nbsp; &nbsp; &nbsp; if mgExt is not &quot;&quot; then set mgExt to &quot;.&quot; &amp; mgExt&nbsp; &nbsp; &nbsp; &nbsp; set text item delimiters of AppleScript to {&quot;.&quot;}&nbsp; &nbsp; &nbsp; &nbsp; set mgOldName to text item 1 of mgName&nbsp; &nbsp; &nbsp; &nbsp; set text item delimiters of AppleScript to &quot;&quot;&nbsp; &nbsp; &nbsp; &nbsp; repeat with x from 1 to count items in mgOriginalNames&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if mgOldName = item x of mgOriginalNames then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set mgNewName to item x of mgOriginalNames &amp; &quot;_&quot; &amp; item x of mgNewNames&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tell application &quot;Finder&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set name of mgItem to (mgNewName &amp; mgExt)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end tell&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end if&nbsp; &nbsp; &nbsp; &nbsp; end repeat&nbsp; &nbsp; end repeatend tell[/CODE]If you can only use a .txt file, you'll have to know exactly how many spaces between entries ('about 5' won't help you). Then relace the comma in this line — set text item delimiters of AppleScript to &quot;,&quot; — with that number of spacesAt the top of that script there's a place for you to enter a &quot;Colon<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />elimited<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />ath:To... &quot; for the list file and the folder containing the files to rename. The easiest way to get this path is to have the file or folder selected in the Finder and then run this script from Script Editor :[CODE]tell application &quot;Finder&quot;&nbsp; &nbsp; get selection as aliasend tell[/CODE]Then just copy and paste the quoted path from the Result window into the appropriate place in the main script.Note that the script in its current form doesn't have any sort of filter to only deal with .mov files — it will rename any files or folders stored in that folder you specify.To change the all caps to lower case you could run the whole lot through the Rename Finder Items action in Automator.Hope that helpsm.</blockquote>

[QUOTE="MacGrunt, post: 1392712, member: 210105"] [B]G'day again[/B] Sorry, I missed the bit about how you don't have Excel. OK, if you're able to export the list as a .csv (comma delimited) file then you could do something like this : [CODE]set mgOriginalNames to {} set mgNewNames to {} tell application "Finder" set mgTheList to "Colon:Delimited:Path:ToYour:ListFile.csv" as alias set mgFolderPath to "Colon:Delimited:Path:ToYour:Folder:" as alias end tell open for access mgTheList set mgList to (read mgTheList) close access mgTheList tell application "Finder" -- split original list into two lists set text item delimiters of AppleScript to "," repeat with x from 1 to count paragraphs of mgList set end of mgOriginalNames to text item 1 of paragraph x of mgList set end of mgNewNames to text item 2 of paragraph x of mgList end repeat set text item delimiters of AppleScript to "" -- get the folder items tell application "Finder" set mgItems to items of (mgFolderPath as alias) end tell -- check name and rename if match is found repeat with mgItem in mgItems set mgName to name of mgItem set mgExt to name extension of mgItem if mgExt is not "" then set mgExt to "." & mgExt set text item delimiters of AppleScript to {"."} set mgOldName to text item 1 of mgName set text item delimiters of AppleScript to "" repeat with x from 1 to count items in mgOriginalNames if mgOldName = item x of mgOriginalNames then set mgNewName to item x of mgOriginalNames & "_" & item x of mgNewNames tell application "Finder" set name of mgItem to (mgNewName & mgExt) end tell end if end repeat end repeat end tell[/CODE] If you can only use a .txt file, you'll have to know [I]exactly[/I] how many spaces between entries ('about 5' won't help you). Then relace the comma in this line — [B]set text item delimiters of AppleScript to ","[/B] — with that number of spaces At the top of that script there's a place for you to enter a "Colon:Delimited:Path:To... " for the list file and the folder containing the files to rename. The easiest way to get this path is to have the file or folder selected in the Finder and then run this script from Script Editor : [CODE]tell application "Finder" get selection as alias end tell[/CODE] Then just copy and paste the quoted path from the [I]Result[/I] window into the appropriate place in the main script. Note that the script in its current form doesn't have any sort of filter to only deal with .mov files — it will rename any files or folders stored in that folder you specify. To change the all caps to lower case you could run the whole lot through the [I]Rename Finder Items[/I] action in Automator. Hope that helps [B]m.[/B] [/QUOTE]

Verification

Name this item 🌈