Masking numeric values only in the address field to '000'

[Jaspal]

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

[Keith Puzey]

Hi,

    You can use the ACCT_01 function to just mask the numeric values

ACCT_01

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.

Parameters

• 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
------------------------------

[Jaspal]

Thank you for your reply, Keith.

 

I see it masks any numeric value to any other numeric values. Which is great.

 

Couple of questions:

·         Is it possible to replace the numeric values to a fixed values , for example '000' (not just any other numeric values) ?

·         Do we have this algorithm available for MF shops too? Since I am masking sql systems and SUPRA DBs (MF) . Can you please confirm if I use this algorithm for SQL systems, then it will be consistently masked in MF too and the availability of this algorithm in MF CA TDM package?

 

Thank you in advance.

 

[Jaspal]

Hello Keith /Broadcom team,

 

Kindly provide your inputs for the below 2 questions.

 

 

Thanks,

Jaspal Singh CA TDM Consultant Information Technology Cluster, WSIB

 

Please let me know if you need this message in an alternative format or accommodation to access this email or its attachments.

Si vous avez besoin de ce message dans un autre format ou d'adaptations pour accéder à ce courriel ou à ses pièces jointes, veuillez m'en informer.

 

 

[Billy Keefer]

Have a look at the translate function.  It exists for both distributive and mainframe
The example below will translate every number to a 0

0123456789
0000000000

[Jaspal]

Hi Billy,

 

Thank you for your reply.

 

I think translate function replaces one specific numeric values to another specific numeric values.

I am not looking to replace one  specific string. My requirement is to replace any numeric values (not character) falling in the address field to fixed values. Example 123 front street 21  to be replaced to 000 front street 000.

System type: Consistent masking  MF and SQL

 

On the side note, it will be very helpful if you can check the list of MF functions and let me know if ACCT_01 is also available for MF masking as the website link under MF masking doesn't explains that.

 

Couple of questions:

·         Is it possible to replace the numeric values to a fixed values , for example '000' (not just any other numeric values) ?

·         Do we have this algorithm available for MF shops too? Since I am masking sql systems and SUPRA DBs (MF) . Can you please confirm if I use this algorithm for SQL systems, then it will be consistently masked in MF too and the availability of th

 

 

 

 

 

 

[Billy Keefer]

First thing...I dont think there is a masking function, ACCT_01 for the mainframe.
With regard to your original request, I think the function regexreplace will do the trick
parm1  (\d){2,9}
parm2 000
However this function is only available on the distributive side of things.

[Jaspal]

Thank you for your reply, Billy.

 

I am looking for an algorithm that consistently mask with the below requirement fulfilled on both distributed and legacy.

 

·         Can you confirm if PARTMASK is available on mainframe and distributed?

·         Since the Broadcom website is not up to date, can you please provide list of functions available on MF with the latest version?

 

 

Thanks,

Jaspal Singh CA TDM Consultant Information Technology Cluster, WSIB

 

Please let me know if you need this message in an alternative format or accommodation to access this email or its attachments.

Si vous avez besoin de ce message dans un autre format ou d'adaptations pour accéder à ce courriel ou à ses pièces jointes, veuillez m'en informer.