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

Andrey Vinokurov
Russian Federation
Local time: 13:33
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: 13:33
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: 13:33
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: 13:33
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: 13:33
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: 13:33
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: 13:33
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: 13:33
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: 13:33
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






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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