Skip to main content

Full Name Masking

The Full Name masking replaces a name with a fictitious name of the same format. This masking option is suitable for full name columns that do not need to be synched with First Name and Last Name columns.

*Note: To keep a full name in sync with first and last names that appear in the same row, use the Compose masking option instead.

Use the Regular Expression masking to insert a value based on a regular expression you define. This masking is suitable for:

  1. Non-standard sensitive data for which there are no pre-built masking formulas.

  2. Data that is constrained to a specific format, specific values, or both.

To apply the Full Name masking, enter the following details:

  1. The Create Format section of the Full Name panel displays various buttons based on which a fictitious full name can be generated. There are ten buttons:

    1. First Name: Click this button to generate the random first name of any person. On clicking the First Name button, ‘F’ is entered in the Generated Format textbox.

    2. Middle Name: Click this button to generate the random middle name of any person. On clicking the Middle Name button, ‘M’ is entered in the Generated Format textbox.

    3. Last Name: Click this button to generate the random last name of any person. On clicking the Last Name button, ‘L’ is entered in the Generated Format textbox.

    4. Comma: Click this button to enter the ‘,’ (comma) to separate two characters or words. This option is useful when you are specifying the Last Name followed by First Name. On clicking the button, ‘,’ (comma) is added in the Generated Format textbox.


      E.g., Conners, Lester. In this example, the Conners being the last name is separated from the first name by comma.

    5. Period: Click this button to enter the ‘.’ (period) while masking the values. This option is useful when you want to abbreviate words such Senior as Sr., Junior as Jr., etc. On clicking the button, ‘.’ (period) is added in the Generated Format textbox.

    6. Space: Click this button to generate a space between two characters. On clicking this button, a space is added between selected options.


      E.g., In the above image, a space is added between First Name, Last Name and Middle Name.

    7. First Initial: Click this button to generate a random first name initial. The range can vary from A-Z, if upper case is chosen in the Case Format else the range can be in between a-z in lowercase. When entering the First Initial, the ‘FI’ is entered in the Generated Format textbox.

    8. Middle Initial: Click this button to generate a random middle name initial. The range can vary from A-Z, if upper case is chosen in the Case Format else the range can be between a-z in lower case. When entering the Middle Initial, the ‘MI’ is entered in the Generated Format textbox.

    9. Prefix: Click this button to generate a random prefix while, masking a name with fictitious value. A prefix can be Mr, Mrs, etc. When entering Prefix, the ‘P’ is added in the Generated Format textbox.

    10. Suffix: Click this button to generate a random suffix while, masking a name with fictitious value. A suffix can be Jr (junior), Sr (senior), I, II, etc. When entering a Suffix, the ‘S’ is added in the Generated Format textbox.

  2. The Generated Format panel displays the regex generated by you for masking a value. To clear the value in the textbox, click the Reset button.

  3. There are three Case Formats based on which the masked value is generated.

    1. Upper Case - If you select the UpperCase option, it generates a random value where every letter of the word is capitalized.

    2. Lower Case - If you select the LowerCase option, it generates a random value where every letter of the word in lowercase.

    3. Title Case - If you select the Title Case option, the data in the field capitalizes the first letter of each word. By default, this option is selected.

E.g., With reference to below image, if you want to mask the data in emp_fname column then use the Full Name masking option. This option retains the format of the data.

In the below image, we have generated a regex ‘P. F MI’ for the Full Name which will generate random fictitious names that are used for masking.

On executing the task, the emp_fname column is masked with random names as per the regex, you define. For instance, the emp_fnameCherry’ whose emp_cd = ‘101 is masked with random emp_fnameMs. Adia N’. Similarly, the names of other employees have been masked using the same regex.



JavaScript errors detected

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

If this problem persists, please contact our support.