SQL filter for Deja Vu X3: source in uppercase Thread poster: Denis Danchenko
|
|---|
Hello dear DVXers,
I was wondering if you could help me create an SQL filter that would:
- display source segments containing words in uppercase only (e. g. DO NOT TRANSLATE ABOVE THIS LINE)
- display source segments containing words both in uppercase and lowercase (e. g. DO NOT translate above this line)
- display as above + alphanumerics (e. g. DO NOT TRANSLATE ABOVE LINE BG3579)
The DVX help available online doesn't seem to address this type ... See more Hello dear DVXers,
I was wondering if you could help me create an SQL filter that would:
- display source segments containing words in uppercase only (e. g. DO NOT TRANSLATE ABOVE THIS LINE)
- display source segments containing words both in uppercase and lowercase (e. g. DO NOT translate above this line)
- display as above + alphanumerics (e. g. DO NOT TRANSLATE ABOVE LINE BG3579)
The DVX help available online doesn't seem to address this type of queries AFAICS.
Thanks so much for your help!
Denis ▲ Collapse
| | | |
Hi Denis,
I have the following statements in my SQL cheat sheet. You can adapt them to your needs:
Show rows in a project which contain only lowercase letters:
StrComp(source, LCase(source), 0) = 0
Show rows in a project which contain only uppercase letters:
StrComp(source, UCase(source), 0) = 0
Show rows in a project which contain at least 1 lowercase letter:
StrComp(source, UCase(source), 0) 0
Show rows in a pr... See more Hi Denis,
I have the following statements in my SQL cheat sheet. You can adapt them to your needs:
Show rows in a project which contain only lowercase letters:
StrComp(source, LCase(source), 0) = 0
Show rows in a project which contain only uppercase letters:
StrComp(source, UCase(source), 0) = 0
Show rows in a project which contain at least 1 lowercase letter:
StrComp(source, UCase(source), 0) 0
Show rows in a project which contain at least 1 uppercase letter:
StrComp(source, LCase(source), 0) 0 ▲ Collapse
| | | | Denis Danchenko 
Ukraine
Local time: 17:15
English to Russian
+ ...
TOPIC STARTER | Thanks a lot :))) | Mar 3, 2020 |
Alessandra Muzzi wrote:
Hi Denis,
I have the following statements in my SQL cheat sheet. You can adapt them to your needs:
Show rows in a project which contain only lowercase letters:
StrComp(source, LCase(source), 0) = 0
Show rows in a project which contain only uppercase letters:
StrComp(source, UCase(source), 0) = 0
Show rows in a project which contain at least 1 lowercase letter:
StrComp(source, UCase(source), 0) 0
Show rows in a project which contain at least 1 uppercase letter:
StrComp(source, LCase(source), 0) 0
Hi Alessandra,
That worked like a charm, thanks
Any chance you could point me to the cheat sheet in case it's available online (e. g. [email protected])?
Thanks again!
[Edited at 2020-03-03 20:53 GMT]
| | | | | Private cheat sheet | Mar 4, 2020 |
Hi Denis, it's a private cheat sheet I have compiled over the time, it's in mixed language (English/Italian) and I cannot vouch for a 100% reliability, but I can share it with you if you want. Sent privately
| | |
|
|
|
Denis Danchenko
Ukraine
Local time: 17:15
English to Russian
+ ...
TOPIC STARTER | Exactly what I need :) | Mar 4, 2020 |
Alessandra Muzzi wrote: Hi Denis, it's a private cheat sheet I have compiled over the time, it's in mixed language (English/Italian) and I cannot vouch for a 100% reliability, but I can share it with you if you want. Sent privately
Hi Alessandra,
Thanks so much, that's been very kind of you!
Your cheat sheet is a treasure for a hopeless data tinkerer like myself.
Warm wishes from Ukraine
| | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » SQL filter for Deja Vu X3: source in uppercase | Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
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 » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
