Hi,
You can use the ACCT_01 function to just mask the numeric values
The ACCT_01 function substitutes digits in the original value with appropriate digits present in Parm1. Each digit in the original value represents a corresponding position in Parm1. And, the digit present at that position in Parm1 is used to replace the digit in the original value.
If Parm1 is not provided, the default value of
2749503168
is used. Regardless of the value for Parm1, the last digit in the masked number is always set to
9
.
The length of the Parm1 value must always include ten digits.
-
Parm1 (Optional)
Specifies the digits to use for replacing the original value.
Applies to:
Numeric and Character
Example:
Consider the following example to understand this function:
Original value:
7564936295
You want to mask this original value with the value provided in Parm1.
Value in Parm1:
6721843283
------------------------------
Regards
Keith Puzey
Client Services Consultant | Enterprise Software Division
Broadcom
------------------------------
Original Message:
Sent: 05-12-2020 10:32 AM
From: Jaspal Singh
Subject: Masking numeric values only in the address field to '000'
Hi All,
Is there a way to JUST mask the numeric values (leave character values as is) in the address field to a fixed value '000'?
For example, I have a address 1234 SAINTE-CATHERINE RUE OUEST SUITE 567 should be masked to 000 SAINTE-CATHERINE RUE OUEST SUITE 000 every time consistently.
I tried PARTMASK algorithm but it assigns random values which are not consistent.
Thank you,
Jaspal