Updated on 2024-05-07 GMT+08:00

Dynamic Data Masking Functions

This function is an internal function.

  • 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

  • basicmailmasking(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

  • fullmailmasking(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