Configure a mask format to limit each character in the output column to an alphabetic, numeric, or alphanumeric character. Use the following characters to define a mask format:
A, D, N, X, +, R
The mask format contains uppercase characters. When you enter a lowercase mask character, the Data Masking transformation converts the character to uppercase.
The following table describes mask format characters:
Alphabetical characters. For example, ASCII characters a to z and A to Z.
Digits 0 to 9. The data masking transformation returns an "X" for characters other than digits 0 to 9.
Alphanumeric characters. For example, ASCII characters a to z, A to Z, and 0-9.
Any character. For example, alphanumeric or symbol.
Remaining characters. R specifies that the remaining characters in the string can be any character type. R must appear as the last character of the mask.
For example, a department name has the following format:
You can configure a mask to force the first three characters to be numeric, the department name to be alphabetic, and the dash to remain in the output. Configure the following mask format:
The Data Masking transformation replaces the first three characters with numeric characters. It does not replace the fourth character. The Data Masking transformation replaces the remaining characters with alphabetical characters.
If you do not define a mask format, the Data Masking transformation replaces each source character with any character. If the mask format is longer than the input string, the Data Masking transformation ignores the extra characters in the mask format. If the mask format is shorter than the source string, the Data Masking transformation masks the remaining characters with format R.
You cannot configure a mask format with the range option.