Glossaries (turning them around) Thread poster: Nicholas Stedman
|
Does anyone know a simple way of turning an english-french glossary into a french-english glossary (for a txt file)
Many thanks for your answers, I tried the Word one first and it worked. The Excel solution looks even simpler for next time!
[Edited at 2005-02-01 18:00] | | | Jeremy Smith United Kingdom Local time: 23:10 Member (2003) French to English + ...
I think there's probably a way of doing it if you open the txt file in Excel. Unfortunately, I don't know how to swap columns around in Excel, but I'm sure it must be possible. | | | vixen Greece Local time: 01:10 English to Dutch + ... Import in Word | Feb 1, 2005 |
1) Open the txt file in Word and select all text (Ctrl-A).
2) Select Table > Convert > Text to table.
3) Select the number of columns for the table.
4) Select the delimiter that was used in the txt file. E.g. if this was a semi-colon ';' enter this sign in the field Other.
5) Select the first (English) column.
6) Use Ctrl-x to delete it from the current position.
7) Select the 2nd column (originally 3rd), right-click and select Paste column.
8) Select th... See more 1) Open the txt file in Word and select all text (Ctrl-A).
2) Select Table > Convert > Text to table.
3) Select the number of columns for the table.
4) Select the delimiter that was used in the txt file. E.g. if this was a semi-colon ';' enter this sign in the field Other.
5) Select the first (English) column.
6) Use Ctrl-x to delete it from the current position.
7) Select the 2nd column (originally 3rd), right-click and select Paste column.
8) Select the entire table and then Table > Sort.
9) Sort by Column1, Ascending.
This will result in a table listing the French terms in alphabetical order in the 1st column and the English terms in the 2nd column.
To convert the file back to a txt file, select the table and then Table > Convert > Table to text. After this, you can save the file again as a text file.
HTH,
Marianne
[Edited at 2005-02-01 11:41]
[Edited at 2005-02-01 11:43] ▲ Collapse | | | Bilingualduo Italy Local time: 00:10 English to Italian + ... Excel - quick and simple | Feb 1, 2005 |
Nicholas Stedman wrote:
Does anyone know a simple way of turning an english-french glossary into a french-english glossary
Hi Nicholas,
I am by NO MEANS an excel expert, but: open Excel, choose import external data and then import data. Choose the text file you want. Select import as tab delimited. Select the cell/row number (by default I think it's A1).
Once the glossary is imported, selected Column A (English) copy and paste to column C (or D or whatever you want). Select the now empty column A and delete the whole column from the edit menu. This should move column B (French) across and it should now be column A. If you pasted the original English column into C this should now be your column B.
Save the file as text delimited with tabs.
Sounds complicated but it's really not.
Others might have a 'neater' way of achieving this, but the concept should get you started.
Bambi | |
|
|
This works, many thanks. | Feb 1, 2005 |
vixen wrote:
1) Open the txt file in Word and select all text (Ctrl-A).
2) Select Table > Convert > Text to table.
3) Select the number of columns for the table.
4) Select the delimiter that was used in the txt file. E.g. if this was a semi-colon ';' enter this sign in the field Other.
5) Select the first (English) column.
6) Use Ctrl-x to delete it from the current position.
7) Select the 2nd column (originally 3rd), right-click and select Paste column.
8) Select the entire table and then Table > Sort.
9) Sort by Column1, Ascending.
This will result in a table listing the French terms in alphabetical order in the 1st column and the English terms in the 2nd column.
To convert the file back to a txt file, select the table and then Table > Convert > Table to text. After this, you can save the file again as a text file.
HTH,
Marianne
[Edited at 2005-02-01 11:41]
[Edited at 2005-02-01 11:43] | | | Robert Zawadzki (X) Local time: 00:10 English to Polish + ... If Excel does not understand a format of a text file... | Feb 1, 2005 |
You can use a specialized tool like AWK (there is a number of free implementations). If you have problems with Excel, send me some lines of your file, and I shall send you an AWK script reversing them. Then you run this script on a whole file, and that's it.
[Edited at 2005-02-01 14:59] | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Glossaries (turning them around) 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 » |
| 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 » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |