WFC: How to remove glossary repetitions?
Thread poster: DZiW (X)
DZiW (X)
DZiW (X)
Ukraine
English to Russian
+ ...
Aug 27, 2018

Is there's a relatively simple way in a newer WordFast Classic to remove duplicates in three glossaries? A colleague got a glossary form her client, and while it does show G1, G2, or G3, but there're too many repetitive entries to track them down manually.

Merging the glossaries doesn't help either for
File is too big too sort!


While there's a "Consider these glossaries as one single glossary_1,2,3", yet re-organizing doesn't remove repetitions for they are still separate files.

TY

[Edited at 2018-08-27 13:48 GMT]


 
Jean Lachaud
Jean Lachaud  Identity Verified
United States
Local time: 01:08
English to French
+ ...
Try the Data Editor Aug 27, 2018

Have you tried the Data Editor (Ctrl+Alt+Enter) ?
You may then try, after selecting a glossary, to click on the Tools tab and, on the Glossary tools tab, click on Mark redundant entries, then click OK. Take a look at the glossary to make sure that redundant entries are marked, then hit the Delete key. At that point, marked entries should have turned into blank lines. To remove them completely from the glossary, hit Ctrl+Delete.

Repeat for all glossaries.

I'm writi
... See more
Have you tried the Data Editor (Ctrl+Alt+Enter) ?
You may then try, after selecting a glossary, to click on the Tools tab and, on the Glossary tools tab, click on Mark redundant entries, then click OK. Take a look at the glossary to make sure that redundant entries are marked, then hit the Delete key. At that point, marked entries should have turned into blank lines. To remove them completely from the glossary, hit Ctrl+Delete.

Repeat for all glossaries.

I'm writing this procedure from memory, I haven't tried it myself.
Collapse


 
Jean Lachaud
Jean Lachaud  Identity Verified
United States
Local time: 01:08
English to French
+ ...
another low-tech idea Aug 27, 2018

If my idea doesn't work, there's a low-tech way:

Open the glossaries in Word or the text editor of your choice, sort the entries in alphabetical order, then manually delete all redundant entries.


 
DZiW (X)
DZiW (X)
Ukraine
English to Russian
+ ...
TOPIC STARTER
Thank you Aug 27, 2018

However, the point is it's about duplicates between three (3) different big glossaries (200k+ entries each), which cannot be rearranged in WFC as a single file.

 
Jean Lachaud
Jean Lachaud  Identity Verified
United States
Local time: 01:08
English to French
+ ...
Excel | Remove duplicates?? Aug 27, 2018

Ah. I see, I may have read your original post too fast.

How about importing each glossaries in Excel, and try "Remove duplicates" (https://support.office.com/en-us/article/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2)??

I've never used the feature on data bases so large, however.


DZiW wrote:

However, the point is it's about duplicates between three (3) different big glossaries (200k+ entries each), which cannot be rearranged in WFC as a single file.


 
Samuel Murray
Samuel Murray  Identity Verified
Netherlands
Local time: 07:08
Member (2006)
English to Afrikaans
+ ...
@DZiW Aug 27, 2018

DZiW wrote:
However, the point is it's about duplicates between three (3) different big glossaries (200k+ entries each), which cannot be rearranged in WFC as a single file.


1. Do you want to remove entries based on identical source text only, based on identical source and target text, or based on the entire glossary entry (i.e. if source and target is identical but the comment is different, then don't delete it)?

2. What operating system is this for?


 


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


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

WFC: How to remove glossary repetitions?







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