Technical forums » Déjà Vu support »
Need help with SQL
Thread poster: mikhailo
mikhailo
mikhailo
Local time: 04:50
English to Russian
+ ...
Aug 12, 2017

I build the SQL to filter segments, that do not containt any western alfabetic characters (numbers, etc).
Search in internet gave me something like that

SOURCE NOT LIKE "%[abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZàáèéòóìíùúÀÁÈÉÒÓÌÍÙÚäöüßÄÖÜ]%"

DVX validates it.
But it doesn't work. In DVX manual also there is no example of SQL with Regex.

Where am I wrong? Does DVX SQL support regexes.

And some... See more
I build the SQL to filter segments, that do not containt any western alfabetic characters (numbers, etc).
Search in internet gave me something like that

SOURCE NOT LIKE "%[abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZàáèéòóìíùúÀÁÈÉÒÓÌÍÙÚäöüßÄÖÜ]%"

DVX validates it.
But it doesn't work. In DVX manual also there is no example of SQL with Regex.

Where am I wrong? Does DVX SQL support regexes.

And some more questions
1. Does regex search in DVX support backreferences?
2. Does regex search in DVX have any reference for Source. (for interfaces string translation, where customer requires to save original and add translation in parenthesis).

[Редактировалось 2017-08-12 19:48 GMT] ▲ Collapse
 


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 »

Need help with SQL






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 »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »