Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

Delimited String Masking

Delimited String Masking

Consistently mask a data substring that occurs anywhere in the data.
A string of data that occurs in a column might appear as a substring in other columns. For example, a first name and last name might appear as strings in a First Name column and a Last Name column, but as substrings in a Full Name column or a Description column.
You might want to mask the first and last names consistently in all columns that they appear in, even as substrings.
You can configure a key string masking rule to include delimited string masking and specify delimiters to identify substrings.
Consider the following data:
First Name
Last Name
Full Name
Description
John
Donne
Donne, John
John Donne, General Manager
Janice
Baker
Baker, Janice
Janice Baker, Department Head
Data that appears as a string in one column appears as a substring in other columns. If you assign the Key masking technique for string data to the First Name and Last Name columns, you ensure that you mask a string with the same value each time it occurs as a string.
You can choose to configure delimited string masking on columns where the strings might appear as substrings. Specify delimiters to determine substrings. In the example, you assign delimited string masking to the Full Name and Description columns and specify comma and space as delimiters.
The masked data in the target could appear as:
First Name
Last Name
Full Name
Description
Patrick
Price
Price, Patrick
Patrick Price, General Manager
Jennifer
Town
Town, Jennifer
Jennifer Town, Department Head
When you specify space and comma as delimiters, the workflow identifies the first and last names when they appear as substrings in other columns.