Friday, December 16, 2011

Examples of useful DejaVU SQL Statements


Punctuation (full stop) Source contains a full stop, target not source like "*.*" and target_XXXX not like "*.*"
Punctuation (bracket) Source contains a full stop, “(“ or “)” is missing in target source like "*(*)*" AND ((target_XXXX like "*)*" and target_XXXX not like "*(*") OR (target_XXXX like "*(*" and target_XXXX not like "*)*"))
Punctuation (bracket) “(“ or “)” is missing in target (target_XXXX like "*(*" and target_XXXX not like "*)*") OR (source like "*)*" and target_XXXX not like "*)*")
Uppercase Source starts with uppercase, target not (all segments must be translated) ((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))
Edited today Target segment has been edited today LastModified_XXXX >= Date()
Character length Number of characters in target is bigger than in source LEN(target_XXXX) > LEN(source)
Character length Number of characters in target is bigger than 42  LEN(Target_XXXX) > 42
Non translatable Segments containing non translatable texts (product name or version, including numbers and letters. E.g.: “A3000IH”). Source LIKE '*[0-9][a-z]*' OR Source LIKE '*[a-z][0-9]*'
Double spacing Target segments containing double spaces Target_XXXX like "*  *"
Source = Target Source and target segments are identical target_XXXX = source