Mobile menu

Multiterm cleanup and removing duplicates
Thread poster: Susanne Lomander

Susanne Lomander  Identity Verified
Sweden
Local time: 08:09
Swedish to English
+ ...
May 5, 2008

I am in the process of reviewing and cleaning up my myriad Multiterm termbases in order to create a couple of unified, subject-specific termbases. I work with 3 languages (Swedish, Spanish and English) and need all my new termbases to be trilingual.

My second problem (just posted problem #1 about unifying EN-GB and EN-US terms in Multiterm) is that, when learning how to use Multiterm 7 I got very confused about which databases were what (due to the new system of numbering the termbases and saving them who knows where), and ended up importing some of them several times. In other words, I have duplicates and triplicates in some databases that I now want to remove, and most probably different termbase definitions as well.

I have exported all my MTWs into excelsheets for now, and was going to start reviewing and cleaning them up. How can I do this easily and speedily (ie make sure all databases have the same structure and are in the same columns), and how do I deal with duplicates and triplicates? Must they be manually deleted in Excel or is there another faster way?

(I suspect I could use filters in MT when importing, but I don't know how they work, and the manuals just leave me blank... Is there anyone with practical, step-by-step experience out there willing to lend a hand...? =)

Thanks!


Direct link Reply with quote
 

Vito Smolej
Germany
Local time: 08:09
Member (2004)
English to Slovenian
+ ...
Partial solution ... May 6, 2008

I have exported all my MTWs into excelsheets for now, and was going to start reviewing and cleaning them up. How can I do this easily and speedily (ie make sure all databases have the same structure and are in the same columns), and how do I deal with duplicates and triplicates?

Its rather convoluted method - in ExCel:
1.) concatenate source and target into one single item (with an underlign as a separator, so you get them apart later on) in a column, called UniqueEntries for instance.
2) make a Pilot table (!) with UniqueEntries - now the unique keys come up only once. Discard the rest of the contents of the table.
3) copy UniqueEntries to a third spreadsheet and tear them apart - using Left, Right, Instr Functions (and the underlign of course).

I had this point of multiple entries entered in the SDL TRADOS ideas database - both a posteriori and when using Convert, where it happens I guess to everybody. The official way out of it is rather lame at the moment - record-by-record deletion somewhere in the MultiTerm menu.

Regards

Vito

[Edited at 2008-05-06 08:01]


Direct link Reply with quote
 


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


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

Multiterm cleanup and removing duplicates

Advanced search


Translation news related to SDL Trados





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 »
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 »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs