Function: RedactSSN

The RedactSSN function is a redaction function that can be used in calculated field expressions.

Description

Numeric digits are replaced with random digits, but adjusted so that the resulting SSN number is not valid.

This function produces redaction results equivalent to Pseudo NHS Number in Input Field Properties Window.

Syntax

RedactSSN(text)

Arguments

Text may be any text field containing an SSN number.

Return Value

This function returns an SSN-looking number, but adjusted so that the resulting SSN number is not valid. Any non-digit characters in the input text are preserved.

Calculated field example

You can create the following expression: RedactSSN(SSN)

If NHS = 078-05-1120, the result can be something like: 923-00-3744.