Found how to «Go to next empty»
Thread poster: mikhailo

Local time: 12:33
English to Russian
+ ...
Dec 7, 2015

I've found how to «Go to next empty»

1. File->Options->SQL
Statement Name — «Next Empty» (w/o quotes)
SQL WHERE Filter Expression — «((Target_XXXX = ''))» (w/o quotes)
Press «Add» button

In «Filters» appears «Next Empty»

In «DB type» shloud be «Project»

Then use it from ribbon

Goto - > next segment matching SQL filter -> Next Empty

the only thing to do - how to add shortcut to this.

A good idea to add some examples of such SQL to manual. Last time I haven't understood how when Atril peoples wrote that «Go to next empty» can be made with SQL.


Local time: 12:33
English to Russian
+ ...
some addendum Dec 7, 2015

How to make filter working not in WORD boundaries.

So that filter «match» find also «matches» etc?

And another good idea — to not filter if there are zero results.


Endre Both  Identity Verified
Local time: 10:33
Member (2002)
English to German
DVX's SQL filtering is great Dec 8, 2015

mikhailo wrote:
the only thing to do - how to add shortcut to this.

Exactly. Having to point and click three times on the ribbon is a real letdown for the marvelous feature of SQL filters.

Regarding word boundaries, if you're talking about the regular filter available in the grid context menu, then you cannot customize that. The source filter filters on whole words (so if you select a partial word and do the filtering, the very segment you filtered from disappears!), while the target filter filters regardless of word boundaries. Don't ask me why it works like this. The SQL filter on the other hand knows no word boundaries.

On not filtering if there are zero results, it's an interesting idea. You won't be able to do that with SQL, but DVX could implement in internally. It might be confusing if DVX simply did nothing, but a message to the effect "This filter produces no segments" might indeed be better than showing an empty grid.



Selcuk Akyuz  Identity Verified
Local time: 12:33
Member (2006)
English to Turkish
+ ...
go to next empty with RegEx Dec 8, 2015

You can use the Find dialogue to go to the next empty segment.

In Find dialogue, check "Use Regular Expressions" and find:



Moreover in DVX3 there is a shortcut for it (though I never used it before)

Next Untranslated on Ribbon (Home Tab)
Next Unconfirmed Ctrl+Shift+Alt+Down Arrow

[Edited at 2015-12-08 08:53 GMT]


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 »

Found how to «Go to next empty»

Advanced search

PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search