Custom SQL filters for Quality Assurance – Atril Solutions

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.

Click on a statement's name to see an explanation of what it will show when used in Déjà Vu.

Name	SQL (Structured Query Language)
Orthography - Consistent Capitalization This highlights segments that have some upper case letters in the source text but no upper case letters in the target, and segments that have no upper case letters in the source but do have some upper case letters in the target.	StrComp(Source, LCase(Source), 0) = -1) XOR (StrComp(Target_XXXX, LCase(Target_XXXX), 0) = -1
Orthography - Consistent Capitalization (ignoring empty segments) This is like the SQL statement above, except that it will not highlight empty segments.	(StrComp(Source, LCase(Source), 0) = -1) XOR (StrComp(Target_XXXX, LCase(Target_XXXX), 0) = -1) AND Target_XXXX <> ""
Punctuation - full stop . This highlights segments in which one column has a full stop but the other does not.	Source LIKE "." XOR Target_XXXX LIKE "."
Punctuation - parentheses () This highlights cells in which the source text has an opening or a closing bracket but the target does not.	(Source like "(" and Target_XXXX not like ")") OR (Source like ")" and Target_XXXX not like ")")
Punctuation - brackets (), [], {}, and <> This is like the query above, but it checks for different kinds of brackets.	(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 ¡, ¿ This highlights segments in which the source text has an exclamation mark or a question mark, and the target does not have a corresponding inverted exclamation or question mark. This is only useful if you are working with a target languages that uses inverted question or exclamation marks.	(Source LIKE "[?]" AND Target_XXXX NOT LIKE "[¿][?]") OR (Source LIKE "!" AND Target_XXXX NOT LIKE "¡!")
Non-translatables - symbols @, ©, %, ‰, ® This highlights segments in which one column has one of the special characters mentioned but the other column does not.	(Source like "@" xor Target_XXXX like "@") or (Source like "©" xor Target_XXXX like "©") or (Source like "%" xor Target_XXXX like "%") or (Source like "‰" xor Target_XXXX like "‰") or (Source like "®" xor Target_XXXX like "®") or (Source like "\" xor Target_XXXX like "\")
Non-translatables - alphanumeric compounds This highlights segments in which one column has a word composed of numerals and letters, but the other column does not.	(Source LIKE '[0-9][a-z]' XOR Target_XXXX LIKE '[0-9][a-z]') OR (Source LIKE '[az][0-9]' XOR Target_XXXX LIKE '[az][0-9]')
Length - target longer than source This highlights segments in which the target text is longer than the source text. This can be useful if you are working with documents that are formatted in such a way that the text cannot be lengthened without disturbing the layout noticeably (this often happens with PowerPoint presentations). Using this SQL statement, you can find segments with translations that are longer than the original text, shorten them, and thus save you a lot of work fixing the layout of the exported document.	LEN(Target_XXXX) > LEN(Source)
Length (subtitles) - longer than 36 characters This is similar to the one above, but it only highlights segments in which the target text is longer than 36 characters, regardless of what's in the source text. You can change the number 36 to any other number you need.	LEN(Target_XXXX) > 36
Spaces - missing space This highlights segments in which one column has at least 1 space but the other column has none.	Source LIKE "* " XOR Target_XXXX LIKE " *"
Spaces - redundant spaces (double blanks) This highlights segments in which one column has a double space but the other column does not.	Source LIKE "* " XOR Target_XXXX LIKE " *"
Spaces - before and after tags This highlights segments in which the spaces before and after tags in the source text do not match those in the target.	(Source LIKE '* {[1-9]} ') XOR (Target_XXXX LIKE '* {[1-9]} ')
Same text in source and target columns This highlights segments in which the source and target text are identical.	Source = Target_XXXX
Segments that have text in the target column This is the opposite of the Empty Segments option in the Segment Selector.	Target_XXXX <> ''
Segments that begin with a lower case letter This will match segments in which the source text begins with a lower case letter.	Source LIKE "[a-z]*" AND StrComp(left(Source,1),lcase(left(Source,1)),0) = 0

Comments