DqStringHandling routine
DqStringHandling routine is composed of portions of code that perform certain quality tasks on arrays of characters. You can use them in the settings of Data Quality components in a Talend Job.
You can access the functions by double-clicking the DqStringHandling node in the system routines folder in the Repository tree view.
|
Function |
Description |
Syntax |
|---|---|---|
|
containsOnlyInitials |
Returns true if the given string contains only initials such as "A", "A.", "A.I." or "A.I.D.S". |
DqStringHandling.containsOnlyInitials |
|
makeSafe |
Returns an empty string when the given string is null. |
DqStringHandling.makeSafe |
|
safeTrim |
Returns the trimmed string or the empty string when the string is null. |
DqStringHandling.safeTrim |
|
safeConcat (String str1, String str2, char separator) |
Returns the concatenation of the trimmed strings. The separator character is used when none of the given strings is empty or null. |
DqStringHandling.safeConcat |
|
safeConcat (char separator, String... strings) |
Returns the concatenation of the trimmed strings. The separator character is used when none of the given strings is empty or null. |
DqStringHandling.safeConcat |
| safeConcatMerge |
Returns the concatenation of the trimmed and unique strings. The separator character is used when none of the given strings is empty or null. If two strings are identical, only one is concatenated. The output order might be different from the input order. |
DqStringHandling.safeConcatMerge |
|
validAscii |
Validates the ascii format or not. |
DqStringHandling.validAscii |