Technical forums » Déjà Vu support »
Found how to «Go to next empty»
Thread poster: mikhailo
mikhailo
mikhailo
Local time: 22:47
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 a... See more
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. ▲ Collapse
 
mikhailo
mikhailo
Local time: 22:47
English to Russian
+ ...
TOPIC STARTER
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
Endre Both  Identity Verified
Germany
Local time: 21:47
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.

Endre
 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 22:47
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:

^$

HTH
Selcuk

--------------------------
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»






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 »
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 »