Morar Bras

I don't think there is an easy way to do this, but depending on the size here's a suggestion:

1. export both TMs to Excel
   1. you could use the Glossary Converter for this to save time
2. do a look up on the EN to map all the SK translations that have FR-EN and EN-SK
3. put matching results against the FR in a new column
4. now you have FR-SK

You will lose context with this since only Trados holds the context.  But that could work.

We did run a developer competition many years ago and the winning app was one that did this.  It was incomplete but the idea was there... but I don't believe it was ever completed.  Might be worth revisiting this to do it properly.  Maybe one for http://ideas.sdl.com

Morar Bras

I don't think there is an easy way to do this, but depending on the size here's a suggestion:

1. export both TMs to Excel
   1. you could use the Glossary Converter for this to save time
2. do a look up on the EN to map all the SK translations that have FR-EN and EN-SK
3. put matching results against the FR in a new column
4. now you have FR-SK

You will lose context with this since only Trados holds the context.  But that could work.

We did run a developer competition many years ago and the winning app was one that did this.  It was incomplete but the idea was there... but I don't believe it was ever completed.  Might be worth revisiting this to do it properly.  Maybe one for http://ideas.sdl.com

Hi Paul,

Thanks very much for your suggestion and I have finally got it to work.

As my TMs are too large to be converted by Glossary Converter (free version), I used Heartsome TMX Editor 8.

A colleague, who knows much more about Excel than me, then found a formula to automatically sort my 173,000 lines, so I now have the FR and matching SK columns and just need to convert them back to to a FR-SK TM.

And as you say, it would be great if SDL could create an app to do this.