The Fixed String masking format replaces column data with a user-specified fixed string.
- Fixed String: The string that should be used to replace the column values. It should be valid for the column size.
Supported Data Types
- Large Object (LOB)
- Combinable: Yes
- Deterministic: Yes
- Reversible: No
- Uniqueness: No
- Suppose you want to replace all the Social Security numbers in a column with
***-**-****. You can use the Fixed String masking format and provide this string as input.
- Alternatively, you can combine multiple basic masking formats to mask a column value. For example, you can use the Fixed String masking format to ensure that the masked value starts with
***-**-. Then, you can use the Random Number masking format to randomly generate the remaining four digits.
- Similarly, you can use the Fixed String masking format to ensure that the license plate numbers in a column start with "CA."