Use Case Accelerators > Securing Data by Masking Using the Translate and Substring Functions

Securing Data by Masking Using the Translate and Substring Functions

Article #: Product: Version:

Summary

Data masking can be used to protect the privacy of your company and clients’ confidential information, such as credit card, bank account, and social security numbers. DMExpress offers a variety of functions that can be used for masking:

Here we provide examples using the Translate and Substring functions along with the concatenate operator.

Resolution

In the following example, different techniques are used to mask the Social Security, Phone, and Account numbers, which are presumed to follow a well-defined format.

Note that some of the techniques allow the original data to be restored by reversing the applied operation, while others irreversibly mutate the data.

Attachments

163_DataMaskingExample.zip, compatible with DMExpress version 7.5.0 or higher

Additional Information

For additional information on DMExpress functions, see DMExpress functions reference in the DMExpress Help.

Last updated: