DataQuality 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

DataQuality routines are portions of code that parse and clean your data. You can use them in the settings of Data Quality components in a Talend Job.

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

Routine

Description

Syntax

getTitle

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

DataQuality.getTitle

getNameWithoutTitle

Returns the string without the title.

DataQuality.getNameWithoutTitle

getNameWithoutSuffix

Returns the string without the suffix.

DataQuality.getNameWithoutSuffix

getLastName

Returns only LastName value from the string.

DataQuality.getLastName

getCleansedLastName

Returns the string without the title and suffix.

DataQuality.getCleansedLastName

isValidName

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

DataQuality.isValidName