Comparing two files with strings and sorting the target file
Dejan Škrebić Bosnia and Herzegovina Local time: 19:42 Member (2011) English to Serbian + ...
TOPIC STARTER
Translation
Jan 27, 2011
Hello,
I have finally sorted and synchronised the two files. I have also used Jabberwock's formula (customized) to compare the two columns, to check if I had missed some strings, which proved useful beacuse I really had.
Now, I have two nice files, identical in string IDs, mostly different in text values of the strings (translated) but also with text identical values (new, untranslated strings).
Note that whatever method you choose you can still take advantage of Excel functions: using a simple comparison you might get only those strings which have the same source and target values (if you only want to extract those) or the opposite - just those which are different (so you can align them and then use for pretranslation). But of course you can do that also with regex - it's just more difficult.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
memoQ translator pro is the premium product for professionals. It is Kilgray's best-selling tool among freelance translators: you get all the functionality available in memoQ in your local environment plus the ability to work on remote servers.
The translation workplace 
