Follow

Custom SQL filters for Quality Assurance

Following are some SQL Statements you can use for the Quality Assurance check, and in the Segment Selector, to highlight segments in the project that have specific problems or features you wish to be alerted to.

Name SQL (Structured Query Language)
Orthography - Consistent Capitalization of first letter
((asc(left(Source,1)) between 97 and 122) AND (asc(left(Target_XXXX,1)) between 65 and 90)) OR ((asc(left(Source,1)) between 65 and 90) AND (asc(left(Target_XXXX,1)) between 97 and 122))
Orthography - Consistent Capitalization
((StrComp(Source, LCase(Source), 0) = -1) AND (StrComp(Target_XXXX, LCase(Target_XXXX), 0) = 0)) OR ((StrComp(Source, LCase(Source), 0) = 0) AND (StrComp(Target_XXXX, LCase(Target_XXXX), 0) = -1))
Orthography - Consistent Capitalization (ignoring empty segments)
(((StrComp(Source, LCase(Source), 0) = -1) AND (StrComp(Target_XXXX, LCase(Target_XXXX), 0) = 0)) OR ((StrComp(Source, LCase(Source), 0) = 0) AND (StrComp(Target_XXXX, LCase(Target_XXXX), 0) = -1))) AND Target_XXXX <> ""
Punctuation - full stop .
source like "*.*" and target_XXXX not like "*.*"
Punctuation - parentheses ()
(target_XXXX like "*(*" and target_XXXX not like "*)*") OR (source like "*)*" and target_XXXX not like "*)*")
Punctuation - brackets (), [], {}, and <>
(Source like '*(*)*' and Target_XXXX not like '*(*)*') OR (Source like '*[[]*[]]*' and Target_XXXX not like '*[[]*[]]*') OR (Source like '*\{*\}*' and Target_XXXX not like '*\{*\}*') OR (Source like '*<*>*' and Target_XXXX not like '*<*>*')
Punctuation - Spanish inverted marks ¡, ¿
(source like "*[?]*" or source like "*!*") and (target_XXXX not like "*[¿]*[?]*" or target_XXXX not like "*¡*!*")
Non-translatables - symbols @, ©, %, ‰, ®
(source like "*@*" or source like "*©*" or source like "*%*" or source like "*‰*" or source like "*®*") and (target_XXXX not like "*@*" or target_XXXX not like "*©*" or target_XXXX not like "*%*" or target_XXXX not like "*‰*" or target_XXXX not like "*®*")
Non-translatables - alphanumeric compounds
Source LIKE '*[0-9][a-z]*' OR Source LIKE '*[az][0-9]*'
Length - target longer than source
LEN(target_XXXX) > LEN(source)
Length (subtitles) - longer than 36 characters
LEN(Target_XXXX) > 36
Spaces - missing space
Source like "* *" and Target_XXXX not like "* *"
Spaces - redundant spaces (double blanks)
Target_XXXX like "*  *" and Source not like "*  *"
Spaces - before and after tags
((Source NOT LIKE '* {*} *') AND (Target_XXXX LIKE '* {*} *')) or ((Source LIKE '* {*} *') AND (Target_XXXX NOT LIKE '* {*} *'))
Same text in source and target columns
Source = Target_XXXX
Segments that have text in the target column
Target_XXXX <> ''
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk