Replace characters between two positions - 7.3

Data privacy

Version
7.3
Language
English (United States)
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
This function masks all characters included in the defined interval, while the ones outside the interval are copied to the output as is.
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 This function requires two extra parameters.

The extra parameters must be numbers, which are the start and the end values of the interval.

You can enter a third extra parameter, which is the replacement character.

In the first example, the first three characters are masked with the defined character.

In the second example, the replacement character is not defined. The second, third and fourth characters are masked with random characters.

Input value Method Extra parameter Example of a masked value
Jack Randomly "1,3,p" pppk
S1000D Randomly "2,4" S0640D