About this task
DataQuality routine is composed of 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 the functions by double-clicking the DataQuality node in the system routines folder in the Repository tree view.
|
Function |
Description |
Syntax |
|---|---|---|
|
getTitle |
Returns the extracted title based on a list of provided titles. |
|
|
getNameWithoutTitle |
Returns the string without the title. |
|
|
getNameWithoutSuffix |
Returns the string without the suffix. |
|
|
getLastName |
Returns only LastName value from the string. |
|
|
getCleansedLastName |
Returns the string without the title and suffix. |
|
|
isValidName |
Returns true/false if the string is a valid/invalid formed name respectively: [Initial] Firstname [Initial] Lastname. |
|