Function: RedactStrikeoutDigits

Description

Redacts the given text by striking out characters with a given overstrike character, optionally keeping any blanks.

Syntax

RedactStrikeoutDigits(text[,overstrike[,keepLastN]])

Arguments

Text may be field of type text.

Overstrike is any alphanumeric character that will replace the field value. This overstrike character should be enclosed in double quotes.

keepLastN is an optional argument that will retain the original last N digits of the input text. This argument should be a number.

Return Value

This functions returns a field value with all digits or some digits replaced by the strikeout character.

Calculated field example

You can create the following expression: RedactStrikeoutDigits(Account, "x")

If Account = 401 023 2137, the result will be: xxx xxx xxxx

 

You can create the following expression: RedactStrikeoutDigits(Account, "x",4)

If Account = 401 023 2137, the result will be: xxx xxx 2137