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
zOQF	TOIFD	TOIFD, zOQF	zOQF TOIFD, 9dI8XUB 3nI3MkF
znIwdk	7nz8X	7nz8X, znIwdk	znIwdk 7nz8X, Tdx3XHNafP Wdyz

When you specify space and comma as delimiters, the workflow identifies the first and last names when they appear as substrings in other columns.