DqStringHandling routines are portions of code that perform certain quality tasks on arrays of characters. You can then use them in the settings of Data Quality components in a Talend Job.
To access these routines:
-
In the Repository tree view of your Studio, expand Code > Routines > system and then double-click DqStringHandling.
The table below gives a description of these routines:
|
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. |
|