Skip to main content

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.

To access the functions, in the Repository tree view, go to Code > Global routines > system and double-click DqStringHandling.

Description and syntax of DqStringHandling routine functions
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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!