Dynamic Data Masking Functions
creditcardmasking(col text, letter char default 'x')
Description: Replaces the digits before the last four bits following the col string with letters.
Parameter: Character string to be replaced or character string used for replacement
Return type: text
basicemailmasking(col text, letter char default 'x')
Description: Replaces the characters before the first at sign (@) in the col string with letters.
Parameter: Character string to be replaced or character string used for replacement
Return type: text
fullemailmasking(col text, letter char default 'x')
Description: Replaces the characters (except @) before the last period (.) in the col string with letters.
Parameter: Character string to be replaced or character string used for replacement
Return type: text
alldigitsmasking(col text, letter char default '0')
Description: Replaces the digits in the col string with letters.
Parameter: Character string to be replaced or character string used for replacement
Return type: text
shufflemasking(col text)
Description: Sorts the characters in the col string out of order.
Parameter: Character string to be replaced or character string used for replacement
Return type: text
randommasking(col text)
Description: Randomizes the characters in the col string.
Parameter: Character string to be replaced or character string used for replacement
Return type: text
regexpmasking(col text, reg text, replace_text text, pos INTEGER default 0, reg_len INTEGER default -1)
Description: Replaces the col string with a regular expression.
Parameters: Character string to be replaced, regular expression, replacement start position, and replacement length.
Return type: text
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
