Technical forums » Apple/Mac operating systems »
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:

Moderator(s) of this forum
Prachya Mruetusatorn[Call to this topic]
Dylan J Hartmann[Call to this topic]
Simone Catania[Call to this topic]

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

Translating file names in macOS






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »