Skip to main content

Character Masking

Character masking replaces one or more characters at the beginning or end of a string with a special character. The Character masking use five types of special characters:

  1. #

  2. %

  3. @

  4. .

  1. The Mask Character drop down displays the list of special characters that are used for masking original data.

  2. The Apply To Left or Right radio buttons let you select the position counter for masking the characters. There are two options:

    1. Left – In this case, the characters starting from left are masked.

    2. Right – In this case, the characters starting from right are masked.

  3. Number of Characters field display the numeric value based on which the characters are masked.

The Character masking is suitable for structured fields with an invariable format, like account or credit card numbers, where:

  1. Only a specific portion of the field is sensitive

  2. Non-sensitive portions contain useful information you want to retain.

  3. Sensitive portion of the data is at the beginning or end of the field.



  • The Character masking is applicable only on string datatypes i.e., varchar, varchar2, char, text, etc.

  • Valid masks include #23456, ### 456, #####6, 12345#, 123###, 1#####, but not 12##56. If you wish to mask a segment in the middle of the structured field, use Intellimask instead.

E.g., with reference to below image, we’ll be masking the data in first_name column of an employee table with $ (dollar sign) then mention the following:

In this example, we are masking the left most two characters of the first name by $ (dollar sign). Therefore, in the below image, we have selected “$” in the Mask Character drop-down. Since we are masking the left most characters therefore, “Left” has been chosen and numeric value “2” specifies that two characters will be masked. 

The final output displays the masked characters in the target table. In the below image, you can see that the first two characters of an employee name has been masked with special character $ (dollar sign). For Instance, John has been replaced by $$hn.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.