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

mikhailo
Local time: 19:23
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.


Direct link Reply with quote
 

mikhailo
Local time: 19:23
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.


Direct link Reply with quote
 

Endre Both  Identity Verified
Germany
Local time: 18:23
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.

Endre


Direct link Reply with quote
 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 19:23
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:

^$

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]


Direct link Reply with quote
 


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






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 »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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