Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The MASK-NUMBER directive applies substitution masking on the column values.

Syntax

Code Block
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.

...

  • Use of # will include the digit from the position

  • Use x or any other character to mask the digit at that position

Examples

Using this record as an example:

...