Keep characters between two positions - 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 keeps all characters included in the defined interval, while the ones outside the interval are removed.
Option Description
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.

In the first example, the first three characters are kept, while the other ones are removed.

In the second example, the second, third and fourth characters are kept, while the other ones are removed.

Input value Extra parameter Example of a masked value
Jack "1,3" Jac
S1000D "2,4" 100