DQTechnical routine - Cloud

Talend Cloud Data Management Platform Studio User Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Management Console
Talend Studio
Content
Design and Development

About this task

DQTechnical routine is composed of portions of code that perform advanced String manipulation. You can use them in the settings of Data Quality components in a Talend Job.

You can access the functions by double-clicking the DQTechnical node in the system routines folder in the Repository tree view.

Function

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