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
© 2024 Altair Engineering Inc. All Rights Reserved.