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: 18:06
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: 18:06
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 | 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 » |
| | Wordfast Pro | Translation Memory Software for Any Platform
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value
Buy now! » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
