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: 00:24 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: 00:24 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 » |
| Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |