DQTechnical routines - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

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