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






Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

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