Translating file names in macOS
Thread poster: Hans Lenting
Hans Lenting
Hans Lenting
Netherlands
Member (2006)
German to Dutch
Jan 31, 2018

1. Open the folder with the files to rename.
2. Press CMD+A, CMD+C.
3. Open MS-Excel.
4. Paste the clipboard content both in the second and third column.
5. Type mv (short for move) in cell A1.
6. Select A1 and drag down until all rows in the second column are preceded with mv.
7. Save and exit MS-Excel.
8. Import the worksheet in your CAT tool (e.g. CafeTran Espresso 2018).
9. Set the import filter to only translate the third
... See more
1. Open the folder with the files to rename.
2. Press CMD+A, CMD+C.
3. Open MS-Excel.
4. Paste the clipboard content both in the second and third column.
5. Type mv (short for move) in cell A1.
6. Select A1 and drag down until all rows in the second column are preceded with mv.
7. Save and exit MS-Excel.
8. Import the worksheet in your CAT tool (e.g. CafeTran Espresso 2018).
9. Set the import filter to only translate the third column.
10. Translate as usual.
11. Export the translated worksheet.
12. Open the translated worksheet in MS-Excel.
13. Press CMD+A, CMD+C.
14. Open BBEdit (or any other text editor).
15. Paste the clipboard content in a new document.
16. Find and replace \t with " ", with the grep checkbox selected.
17. Find and replace \r with "\r, with the grep checkbox selected.
18. Add one " at the end of the last row.
19. Find and replace mv" with mv, to remove superfluous double quotes.
20. Save the file as translate.txt, in the same folder as the files that you want to rename and exit BBEdit.
21. Open the Terminal and navigate to the folder containing the file translate.txt and the files that you want to rename.
22. Type bash translate.txt.

Do you know a solution that requires less steps?

[Edited at 2018-01-31 08:03 GMT]
Collapse


 
Post removed: This post was hidden by a moderator or staff member because it was not in line with site rule


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Translating file names in macOS






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »