Function: RedactTextWithConsistentAlias
The RedactTextWithConsistentAlias function is a redaction function that can be used in calculated field expressions.
Description
RedactTextWithConsistentAlias replaces original text in a field value with a random pattern of alphanumeric characters.
This function also ensures that all instances of a field value are replaced consistently across the entire report.
For instance, if you have an Account Number AC 123446 occurring 5 times within a report, using this method will replace all occurrences of AC 123446 with X3y981043. This will allow you to aggregate or summarize on X3y981043 and get the correct results.
This function produces redaction results equivalent to Consistent alias text in Input Field Properties Window.
Syntax
RedactTextWithConsistentAlias(text)
Arguments
Text may be any field of type text containing numbers.
Return value
This function returns random digits for a given field value.
Calculated field example
If you have a field named Account Number with the following values:
-
-
AC 123456
-
AC 333456
-
AC 333456
-
AC 123456
-
AC 123444
-
Using the function RedactTextWithConsistentAlias([Account Number]) will produce the following result:
-
-
X3y98104x
-
UVn876v43
-
UVn876v43
-
X3y98104x
-
TvRA1D4F4
-
© 2024 Altair Engineering Inc. All Rights Reserved.