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: 19:25 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: 19:25 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 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! » |
| CafeTran Espresso | You've never met a CAT tool this clever!
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Buy now! » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |