Fixed String

Purpose

The Fixed String masking format replaces column data with a user-specified fixed string.

Inputs

• Fixed String: The string that should be used to replace the column values. It should be valid for the column size.

Supported Data Types

• Character
• Large Object (LOB)

Characteristics

• Supports Double-Byte Characters: Yes
• Combinable: Yes
• Deterministic: Yes
• Reversible: No
• Uniqueness: No

Examples

• 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."