DqStringHandling routine - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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