DQTechnical routines - Cloud

Talend Cloud Data Management Platform Studio User Guide

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

About this task

DQTechnical routines are portions of code that perform advanced String manipulation. You can then use them in the settings of Data Quality components in a Talend Job.

To access these routines:

Procedure

In the Repository tree view of your Studio, expand Code > Routines > DQTechnical and then double-click DqStringHandling.

Results

The table below gives a description of these routines:

Routine

Description

Syntax

extractTitle

Returns the extracted title based on a list of provided titles.

DQTechnical.extractTitle

removeTitle

Returns the string without the title.

DQTechnical.removeTitle

extractLastName

Returns the string without the last name.

DQTechnical.extractLastName

removeNameSuffix

Returns the string without the suffix.

DQTechnical.removeNameSuffix

isNameStringValid

Returns true or false if the string is a valid formed name: [Initial] Firstname [Initial] Lastname.

DQTechnical.isNameStringValid