Technical forums » Déjà Vu support »
Need help with SQL
Thread poster: mikhailo
mikhailo
mikhailo
Local time: 00:13
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






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

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