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






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
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 »