Skip to main content Skip to complementary content
Qlik Resources
Announcements
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Email masking functions

You can mask email addresses.
Function Random masking Consistent masking Format-preserving encryption Input data validation
Mask email full domain by character Yes Yes No Yes
Mask email left part of domain by character Yes Yes No Yes
Mask email local part by character Yes Yes No Yes

Mask email local part

This function masks all characters before the @ character. Two methods are available: By character and From a list of values.

This function only applies on Strings.

This function requires an extra parameter.

Option Description
Method When using the By character method, this function masks what comes before the @ character with a character.

When using the From a list of values method, this function masks what comes before the @ character with one of the values from the specified list.
Extra parameter This function requires an extra parameter.

When using the By character method, the extra parameter must be a character. If you specify an invalid extra parameter, like a string, a list, multiple characters or a digit, all characters before the @ character will be masked with X characters by default.

When using the From a list of values, the extra parameter can be a comma-separated list of values or a path to a file containing a list of values. If you do not specify an extra parameter, all characters before the @ character are removed.
In the first example, all characters before the @ character are masked with the user-defined characters.

In the second example, all characters before the @ character are masked with one of the values from the user-defined list.

Input value Method Extra parameter Example of masked value
johnsmith@company.com By character "p" ppppppppp@company.com
johnsmith@company.com From a list of values "z,x,c,h" xxxxxxxxx@company.com

Mask email full domain

This function masks what comes after the @ character. Two methods are available: By character and From a list of values.

This function only applies on Strings.

Option Description
Method When using the By character method, this function masks what comes after the @ character with a character.

When using the From a list of values method, this function masks what comes after the @ character with one of the values from the specified list.
Extra parameter This function requires an extra parameter.

When using the By character method, the extra parameter must be a character. If you specify an invalid extra parameter, like a string, a list, multiple characters or a digit, all characters after the @ character will be masked with X characters by default.

When using the From a list of values, the extra parameter can be a comma-separated list of domains or a path to a file containing a list of domains. If you do not specify an extra parameter, all characters after the @ character are removed.
In the following example, all characters after the @ character are masked with one of the values from the user-defined list.
Input value Method Extra parameter Example of a masked value
johnsmith@company.com From a list of values "newtalend.com,newcompany.org" johnsmith@newtalend.com

Mask email left part of domain

This function masks what comes between the @ character and the dot in e-mail adresses. Two methods are available: By character and From a list of values.

This function only applies on Strings.

Option Description
Method When using the By character method, this function masks what comes between the @ character and the dot with a character.

When using the From a list of values method, this function masks what comes between the @ character and the dot with one of the values from the specified list.
Extra parameter This function requires an extra parameter.

When using the By character method, the extra parameter must be a character. If you specify an invalid extra parameter, like a string, a list, multiple characters or a digit, all characters between the @ character and the dot will be masked with X characters by default.

When using the From a list of values, the extra parameter can be a comma-separated list of domains or a path to a file containing a list of domains. If you do not specify an extra parameter, all characters between the @ character and the dot are removed.
In the following example, all characters between the @ character and the dot are masked with one of the values from the user-defined list.
Input value Method Extra parameter Example of a masked value
johnsmith@company.com From a list of values "newtalend,talendforge" johnsmith@newtalend.com

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here