DqStringHandling routines are 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 these routines by double-clicking the DqStringHandling node in the system routines folder in the Repository tree view.
|
Routine |
Description |
Syntax |
|---|---|---|
|
containsOnlyInitials |
Returns true if the given string contains only initials such as "A", "A.", "A.I." or "A.I.D.S". |
|
|
makeSafe |
Returns an empty string when the given string is null. |
|
|
safeTrim |
Returns the trimmed string or the empty string when the string is null. |
|
|
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. |
|
|
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. |
|
|
validAscii |
Validates the ascii format or not. |
|