Mask Number directive
The MASK-NUMBER directive applies substitution masking on the column values.
Syntax
mask-number :columm 'mask'
The
column
specifies the name of an existing column to be masked.The
mask
is a substitution pattern to be used to mask the column values.
Usage Notes
Substitution masking is generally used for masking credit card or social security numbers. The MASK-NUMBER applies substitution masking on the column values. This type of masking is fixed masking, where the pattern is applied on the fixed length string.
These rules are used for the pattern:
Use of
#
will include the digit from the positionUse
x
or any other character to mask the digit at that position
Examples
Using this record as an example:
{
"first": "Root",
"last": "Joltie",
"ssn": "000-00-0000",
"cc": "4929790943424701"
}
Applying this directive:
mask-number ssn XXX-XX-####
results in this record:
Applying this directive:
results in this record:
Created in 2020 by Google Inc.