Working with duplicates in Deja Vu X3
Thread poster: Andrey Vinokurov

Andrey Vinokurov
Russian Federation
Local time: 18:42
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
Local time: 18:42
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  Identity Verified
Turkey
Local time: 18:42
Member (2006)
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
Russian Federation
Local time: 18:42
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!icon_smile.gif That's exactly what I needed, and it works. Many thanks!


 

mikhailo
Local time: 18:42
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  Identity Verified
Turkey
Local time: 18:42
Member (2006)
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
Local time: 18:42
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  Identity Verified
Turkey
Local time: 18:42
Member (2006)
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
Local time: 18:42
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

Advanced search






WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search