How to export a Translation Memory or part of it

Déjà Vu X2 allows you to export only a subset of all the segments contained in a Translation Memory. You can do this by typing an SQL statement in the Filtering Options part of the Translation Memory Export Wizard. This will instruct the Wizard to export only the segments that match the condition specified in the SQL Statement.

Following is an example of this procedure that will allow you to export only segments that are duplicated in the Translation Memory:

1. If you have not done so already, have Déjà Vu X2 find the duplicate segments by accessing the menu option Database>Find Duplicate Segments. This locates duplicate segments and marks them as such, so that Déjà Vu X2 will know which ones they are when performing other operations on them.
2. Access the menu option File>Export>External Data.
3. Complete the wizard until you get to the Filtering Conditions page.
4. In the text input area of this page, type the following SQL statement:
   ID IN (SELECT ID From Sentences WHERE Duplicate=-1)
5. Proceed with the wizard.

You will see that only the duplicate segments contained in the Translation Memory (if any) were exported.

If you have some knowledge of SQL, you can create your own statements to use in place of the one in step 4 above. however, if you are not an SQL expert, you can find a list of sample statements in the User Guide that you can use to filter specific segments when you export from a Translation Memory. Look the chapter called Samples of Regular Expressions for Export from Translation Memory and Terminology Database.