Version 1.1.1
 —  Data Masking  —

Masking Substrings

It is also possible to mask substrings in columns containing character datatypes. In order to do this, enter values for BOTH the "Substr start" and "Substr length" columns in the mapping csv.

Note:
The values must both be integers > 0 (positioning starts at the value 1, not at 0).

Masking function should not be SHUFFLE, WHERE, AND, OR, DELETE or TRUNCATE.


Masking Substrings That Differ in Length from Value

graphics/GTSDM_img_29.jpg

Top of page

Applying Multiple Functions to the Same Column

When applying multiple functions to the same column, the functions should be listed in consecutive rows in the mapping csv, as shown below:

graphics/GTSDM_img_30.jpg

There is no limit to the number of masking functions performed on each column, however, KeepNulls should be set the same for all of these functions.

Notes:

  1. All functions MUST HAVE a "substr start" and "substr length" set. Substr specifications for different functions can refer to the same character positions.
  2. If using cross-references, they can only be set for the last function used on each column.

graphics/GTSDM_img_31.jpg

In the example above, the mapping csv shows that a mask of column ACCOUNT_NUMBER in table PAYMENT_OPTIONS with a zero padded sequence in positions 7 to 16, expressed as:

caaccounts,numberx,SEQNUMBER,1000000001,,,,,,,,,,7,10,
caaccounts,numberx,FIXED,0,,,,,,,,,,7,1,

Note:
SEQNUMBER returns a left-aligned non-padded number, so the sequence is started at 1000000001 and the leading digit is then set to 0.

In the audit report, the function names will be suffixed with start:length parameters and concatenated together, for example, "SEQNUMBER(7:10) FIXED(7:1)"

Note:
If cross-referencing is specified, the value used to lookup and update the cross reference table is the whole column value, not a substring of the value.

Top of page