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:

1. • AC 123456

   • AC 333456

   • AC 333456

   • AC 123456

   • AC 123444

Using the function RedactTextWithConsistentAlias([Account Number]) will produce the following result:

1. • X3y98104x

   • UVn876v43

   • UVn876v43

   • X3y98104x

   • TvRA1D4F4