• State Suggested Answer
  • Replies 9 replies
  • Answers 3 answers
  • Subscribers 192 subscribers
  • Views 5223 views
  • Users 0 members are here
Options
Related

How to identify terms where the same target terms are translated differently between two Multiterm termbases?

Chunyi Chen

Dear Multiterm experts,

I would like to compare two similar termbases and identify the target terms that are translated differently.  One termbase is managed by me, and the other termbase is sent by the client where some target terms were updated internally. I would like to find those updated terms.

I tried using GC to merge these two termbases but probably due to my incorrect settings GC dropped one term and kept the other when it found differences for the same item.

Thank you for your suggestions.

Chunyi 
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0

    Hi Chunyi,

    I would use Glossary Converter to find differences in the translations between two termbases.

    1. Convert the termbases to Excel with Glossary Converter.
    2. Open termbase 1 and 2 and paste the target column from termbase 2 into a new column in termbase 1 so that the result is an Excel file with three columns, source, target 1, target 2.
    3. In column 4, enter the formula =IF(B2=C2;"";"Diff") and fill the formula all the way down to the last term (Ctrl + D).
    4. The translations that differ will be marked with ”Diff” in column D, you can set an autofilter and filter for those terms to view them easily.

    If you want the opposite, to mark up the similarities, you can change the formula to this, =IF(B2=C2;"No difference";"")

    Or combine the two, like this =IF(B2=C2;"No difference";"Diff"), so that you can filter for both ”No difference” and ”Diff”, depending on what you want to see.

    Bonus tip: An easy way to avoid filling column D all the way to the bottom om the Excel file (1,000,000 + rows, which might take some time) in a table like the above is to go to one of the language columns and press Ctrl + down arrow. Then move to column D (where you want to fill the formula) and just write something in that cell, for example ”end”. Then go to first row and press Ctrl + shift + D to fill the formula all the way down to where you wrote ”end”, instead of all the way to the bottom of the Excel file.

    Daniel Fransson | SDL Sweden

  • 0 in reply to Daniel Fransson

    Hi Chunyi,

    You can export the termbases to excel files using GC. Then just compare those two excel files using the Spreadsheet Compare function. This program is included in MS Office, you can open it by All Programs - Microsoft Office 2016 (or earlier version) . Very easy to use. Just select the two files and compare. I attached an small example. Hope it helps. 

     

    Regards,

    Ivan
Reply Children