Replace all letters - 7.3

Data privacy

Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Data privacy components
Data Quality and Preparation > Third-party systems > Data Quality components > Data privacy components
Design and Development > Third-party systems > Data Quality components > Data privacy components
Last publication date
2024-04-03
This function masks all letters from the input values.
Option Description
Method The Randomly method randomly selects a character. As a result, two identical input values can be masked with different output values.

When the same value appears twice in the input data, the Consistently method ensures that the function outputs the same masked value in the same Job execution.

This function can encrypt the output masked values in the same format as the input values, using Format-Preserving Encryption (FPE) methods:

  • FF1 with AES relies on the Advanced Encryption Standard in CBC mode.
  • FF1 with SHA-2 relies on the secure hash function HMAC-256.

The FPE methods are bijective methods, except when using tweaks.

The FF1 with AES and FF1 with SHA-2 methods require a password to generate encrypted and repeatable masked values. Those FPE methods do not use a seed.

You can specify this password in the password for FF1 method field, from the Advanced Settings of the component.

Extra parameter

The optional extra parameter is the replacement character.

In the first example, the replacement character is not defined. All letters are masked with random characters.

In the second example, all letters are masked with the defined character.

Input value Method Extra parameter Example of a masked value
Jack Randomly "" Zvxn
S1000D Randomly "q" q1000q