Need help with SQL
Thread poster: mikhailo

mikhailo
Local time: 08:20
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

Advanced search






SDL Trados Business Manager Lite
Create customer quotes and invoices from within SDL Trados Studio

SDL Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

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 »



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