Hello,

Based on your query, you want to export the untranslated segments (where source is identical to target) from your Translation Memory (TM) and then delete them. Here's how you can do it:

Step 1: Backup your TM. This is a crucial step to prevent any loss of data.

Step 2: Open your TM in a SQLite editor. You can use any SQLite editor, such as DB Browser for SQLite.

Step 3: Check for untranslated segments (where source is identical to target) by executing the following query:

SELECT source_segment, target_segment FROM translation_units WHERE substr(source_segment, instr(source_segment, '<Value>') + 7, instr(source_segment, '</Value>') - instr(source_segment, '<Value>') - 7) = substr(target_segment, instr(target_segment, '<Value>') + 7, instr(target_segment, '</Value>') - instr(target_segment, '<Value>') - 7);

Step 4: If there are any untranslated segments, delete them with the following statement:

DELETE FROM translation_units WHERE substr(source_segment, instr(source_segment, '<Value>') + 7, instr(source_segment, '</Value>') - instr(source_segment, '<Value>') - 7) = substr(target_segment, instr(target_segment, '<Value>') + 7, instr(target_segment, '</Value>') - instr(target_segment, '<Value>') - 7);

Step 5: Execute the VACUUM command. This will optimize the TM database, reclaim any unused space, and improve the performance of the TM.

Step 6: Open the TM in Trados Studio in the Translation Memory View and select "Recompute Fuzzy Index Statistics...", then "Re-index Translation Memory".

Step 7: Verify that the number of deleted segments from the DB Browser matches the number shown in Trados Studio.

Please remember to be cautious when working with SQLite queries. If you're unsure, it's always best to seek help from someone with experience in this area.

I hope this helps! If you have any other questions, feel free to ask.

Best regards,

RWS Community AI

I also need to export those segments before delete, how can I do?

Hello Henry Huang 

The AI might not be aware yet that there is a new app in the Appstore called "TM Fusion". On the whole it's not an easy to use app (yet), but what you want to do is very easy indeed. Download the app, open your TM, go to the "Trados" tab and in "Filter" you select "Source equals Target", then you select "Batch Delete". That's it. Beware, this is something like a beta version and there is no "Undo". But it's the answer to prayer for many of us.

Daniel

Hello Henry Huang 

The AI might not be aware yet that there is a new app in the Appstore called "TM Fusion". On the whole it's not an easy to use app (yet), but what you want to do is very easy indeed. Download the app, open your TM, go to the "Trados" tab and in "Filter" you select "Source equals Target", then you select "Batch Delete". That's it. Beware, this is something like a beta version and there is no "Undo". But it's the answer to prayer for many of us.

Daniel