Skip to main content

Regular Expression

The Regular Expression masking inserts 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 value, or both.

This masking is applied on the columns having string datatype such as char, varchar, varchar2, etc. To apply Regular Expression masking, you can choose any given option provided with the value, to generate a regex.

  1. The top section Create Regular Expression (Select Operator And Click Add) shows the list of options based on which you can create a regex value.

  2. The Column Properties display the value of regular expression and its length. The length can’t exceed beyond the datatype’s characteristics.

E.g., with reference to below image, if you want to mask the first _name in the target database using random values, you can create a random regex value by selecting an option based on your requirement. 

Here, we have created a random regex i.e. [d-t]{1,2}[^iou] which is of length of three characters. The expression here is defined as:

  1. [d-t] – The first character is chosen from the range ‘d’ to ‘t’.

  2. {1,2} – The second character here displays the number of times the value ‘n’ will be generated.

  3. [^iou] – The third character here displays the list of alphabets which are not considered while masking. In this scenario, the alphabets ‘i,o,u’ are not used for masking.

In the below image, on executing the task, the data in the target database is masked using the regex you define. For Instance, the first_name= Ben is masked with fictious value ‘ttT’. Similarly, data for remaining records are also masked.

JavaScript errors detected

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

If this problem persists, please contact our support.