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.”