Working with duplicates in Deja Vu X3
Thread poster: Andrey Vinokurov
Andrey Vinokurov
Andrey Vinokurov
Russian Federation
Local time: 23:29
English to Russian
Feb 24, 2016

Hello,

I am proofreading a file with lots of duplicated strings, and want to hide them all except 1st occurrences (to proofread them too). Workflow with marking duplicates and SQL filter '(Duplicate = 0)' hides all dupes including 1st occurrences.
Is there a way to see 1 original per string and hide all other copies of it?

Many thanks in advance!


 
mikhailo
mikhailo
Local time: 23:29
English to Russian
+ ...
re Feb 24, 2016

Andrey Vinokurov wrote:

Hello,

I am proofreading a file with lots of duplicated strings, and want to hide them all except 1st occurrences (to proofread them too). Workflow with marking duplicates and SQL filter '(Duplicate = 0)' hides all dupes including 1st occurrences.
Is there a way to see 1 original per string and hide all other copies of it?

Many thanks in advance!



External View with duplicate suppressing


 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 23:29
English to Turkish
+ ...
SQL Feb 24, 2016

Hi Andrey,


First Instance of Each Duplicate Segment:

Duplicate = -1 AND DupNoCount = 0


All Segments + First Instance of Each Duplicate Segment:

(Duplicate = 0) OR (Duplicate = -1 AND DupNoCount = 0)


 
Andrey Vinokurov
Andrey Vinokurov
Russian Federation
Local time: 23:29
English to Russian
TOPIC STARTER
It works! Feb 24, 2016

Selcuk Akyuz wrote:
All Segments + First Instance of Each Duplicate Segment:
(Duplicate = 0) OR (Duplicate = -1 AND DupNoCount = 0)


Hi Selcuk,

You rocks! That's exactly what I needed, and it works. Many thanks!


 
mikhailo
mikhailo
Local time: 23:29
English to Russian
+ ...
re Feb 24, 2016

Selcuk Akyuz wrote:

Hi Andrey,


First Instance of Each Duplicate Segment:

Duplicate = -1 AND DupNoCount = 0


All Segments + First Instance of Each Duplicate Segment:

(Duplicate = 0) OR (Duplicate = -1 AND DupNoCount = 0)



Selcuk Akyuz

Please help to make a filter for segments with spelling errors.


 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 23:29
English to Turkish
+ ...
segments with spelling errors Feb 24, 2016

mikhailo wrote:

Please help to make a filter for segments with spelling errors.


AFAIK it is not possible with SQL but you can use the EV RTF file. Using the modified version of DVXEV v_1_1 dot file you can highlight spelling errors and add {spelling error}word{spelling error} tags; e.g.



There is a spelling {spelling error}erroor{spelling error} here.

Next you can use an SQL filter like

Target_XXXX LIKE "*{spelling error}*"

The DVXEV v_1_1 file was uploaded to Yahoo Deja Vu group long ago but it seems the file is deleted. I will send you a copy of the file.


In this file, two new macros were added for spell checking. Before running these two macros hide all columns except the Target column and make sure hidden formatting symbols are not displayed.


[Edited at 2016-02-24 22:34 GMT]


 
mikhailo
mikhailo
Local time: 23:29
English to Russian
+ ...
re Feb 29, 2016

Selcuk Akyuz wrote:

AFAIK it is not possible with SQL but you can use the EV RTF file. Using the modified version of DVXEV v_1_1 dot file you can highlight spelling errors and add {spelling error}word{spelling error} tags; e.g.



There is a spelling {spelling error}erroor{spelling error} here.

Next you can use an SQL filter like

Target_XXXX LIKE "*{spelling error}*"

The DVXEV v_1_1 file was uploaded to Yahoo Deja Vu group long ago but it seems the file is deleted. I will send you a copy of the file.


In this file, two new macros were added for spell checking. Before running these two macros hide all columns except the Target column and make sure hidden formatting symbols are not displayed.


[Edited at 2016-02-24 22:34 GMT]


Thanks. Not needed. Free Verifika do it well.
May be You now solution for segment separation on tabs for Office Live filter?


 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 23:29
English to Turkish
+ ...
tabs Mar 1, 2016

mikhailo wrote:
May be You now solution for segment separation on tabs for Office Live filter?


I don't use the Live filter but the following Segmentation Rules (not Exceptions) may help.

Before split: ^$ After split: tab (copy/paste a tab character)
Before split: tab (copy/paste a tab character) After split: ^$

^$ is any letter (lowercase or uppercase), so you may consider adding new rules with ^# as well

I am not sure but ^? may catch all

Before split: ^? After split: tab (copy/paste a tab character)
Before split: tab (copy/paste a tab character) After split: ^?


----------------
Yes, it works even for multiple tab characters, e.g.

word1 word2tabtabword3
segmented as:
word1 word2
word3



[Edited at 2016-03-01 20:36 GMT]


 
mikhailo
mikhailo
Local time: 23:29
English to Russian
+ ...
re Mar 4, 2016

Selcuk Akyuz wrote:

mikhailo wrote:
May be You now solution for segment separation on tabs for Office Live filter?


I don't use the Live filter but the following Segmentation Rules (not Exceptions) may help.

Before split: ^$ After split: tab (copy/paste a tab character)
Before split: tab (copy/paste a tab character) After split: ^$

^$ is any letter (lowercase or uppercase), so you may consider adding new rules with ^# as well

I am not sure but ^? may catch all

Before split: ^? After split: tab (copy/paste a tab character)
Before split: tab (copy/paste a tab character) After split: ^?


----------------
Yes, it works even for multiple tab characters, e.g.

word1 word2tabtabword3
segmented as:
word1 word2
word3



[Edited at 2016-03-01 20:36 GMT]


thanks a lot. (to paste tab) haven't come to my mind.


 


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

Moderator(s) of this forum
Pavel Tsvetkov[Call to this topic]

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

Working with duplicates in Deja Vu X3






Anycount & Translation Office 3000
Translation Office 3000

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.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »