Substring

Purpose

The Substring masking format extracts a portion of the original column value, and uses that to replace the original value. This masking format is similar to the SUBSTR database function.

Inputs

• Start Position: The starting position in the original string from where the substring should be extracted. The start position can be either a positive or a negative integer. If the start position is negative, the counting starts from the end of the string.
• Length: The number of characters that you want in the substring. It should be an integer and greater than zero.

Supported Data Types

• Character

Characteristics

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

Example

Suppose an original column value is abcd. A substring with a start position of 2 and length of 3 generates a masked string of bcd. A substring with start position of -2 and length of 3 generates a masked string of cd.