Function: RedactStrikeout

Description

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

Syntax

RedactStrikeout(text[,overstrike[,keepBlanks]])

Arguments

Text may be a field of type text.

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

keepBlanks is an optional argument that will retain blanks in the input text. If this option is not included, blanks are also replaced with the overstrike character by default. Valid values for keepBlanks are:

• 0 to ignore blanks

• 1 to keep blanks

Return Value

This functions returns a field value with all characters replaced by the strikeout character.

Calculated field example

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

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

 

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

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