Technical forums » MemoQ support »
How to easily remove duplicate entries from a TB?
Thread poster: pjg111
pjg111
pjg111  Identity Verified
Local time: 18:43
English to French
Jan 20, 2021

Hi everybody,

Could someone share their experience and suggest good practices to eliminate duplicate entries from term bases either from within MemoQ or in an external way?

Many thanks in advance for any clue.

Cheers.
 
Recep Kurt
Recep Kurt  Identity Verified
Türkiye
Local time: 19:43
Member (2011)
English to Turkish
+ ...
Goldpan Editor Jan 20, 2021

This free utility allows you to open TMX, SDLTM, XLIFF, SDLXLIFF, TBX files and filter the contents (find the duplicates) etc.
https://logrusglobal.com/goldpan.html (you need to have a 64-bit Windows OS, though)
 
pjg111
pjg111  Identity Verified
Local time: 18:43
English to French
TOPIC STARTER
How to easily remove duplicate entries from a TB? Jan 20, 2021

Recep Kurt wrote:

This free utility allows you to open TMX, SDLTM, XLIFF, SDLXLIFF, TBX files and filter the contents (find the duplicates) etc.
https://logrusglobal.com/goldpan.html (you need to have a 64-bit Windows OS, though)


Thanks for the tip. I will try it and revert to let you know the outcome.
 
adrianrff
adrianrff
Venezuela
English to Spanish
Export as Excel as an alternative Jan 21, 2021

If you know your way around Excel, you can export the TB as an .xlsx and manipulate it en Excel, being mindful of the formatting, of course, which is fairly straighforward. The you reimport your clean Excel file into a new, empty TB.

[Edited at 2021-01-21 18:08 GMT]

pjg111
 
pjg111
pjg111  Identity Verified
Local time: 18:43
English to French
TOPIC STARTER
How to easily remove duplicate entries from a TB? Jan 24, 2021

pjg111 wrote:

Recep Kurt wrote:

This free utility allows you to open TMX, SDLTM, XLIFF, SDLXLIFF, TBX files and filter the contents (find the duplicates) etc.
https://logrusglobal.com/goldpan.html (you need to have a 64-bit Windows OS, though)


Thanks for the tip. I will try it and revert to let you know the outcome.


Interesting tip but unfortunately I have been unable to have a tbx available. So I chose the Excel route as suggested by adrianrff.

[Edited at 2021-01-24 22:55 GMT]
 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 19:43
English to Russian
Why not use memoQ itself? Jan 25, 2021

Go to 'Term bases' view, select your TB, plress Edit, press Show Duplicates.
 
pjg111
pjg111  Identity Verified
Local time: 18:43
English to French
TOPIC STARTER
How to easily remove duplicate entries from a TB? Jan 25, 2021

Stepan Konev wrote:

Go to 'Term bases' view, select your TB, plress Edit, press Show Duplicates.


Thanks for the suggestion. Actually I had tried the feature but I did not mention it in my previous replies. While it allowed me to achieve the desired result, Excel route may be easier and give me a better insight on my TB records.

Anyway I warmly thank all those who replied my query and made helpful suggestions.

Cheers.
 


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

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Peter Zauner[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

How to easily remove duplicate entries from a TB?






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 »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »