DqStringHandling routines - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio

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:

  1. 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".

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

validAscii

Validates the ascii format or not.

DqStringHandling.validAscii