REPLACE Function - MainFrame

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We don't have a function that allows to replace a list of values based on a regex.

We have currently a case that needs this option because we want to mask only the numerics in an address field.

Example: 374 Rue du Test should be mask as 111 Rue du Test

In the standard TDM (not mainframe), we have the REGEXPREPLACE function.

Is it possible to have a similar function on the Mainframe ?

If not, do you have a workaround that allows to do this type of masking ?

 

Available function in Mainframe:

Available function in standard TDM:

Environment

TDM Mainframe 6.0.04 and later.

Cause

There is no function that allows to replace a list of values based on a regex for mainframe.

Resolution

Engineering has just developed the REGEXPREPLACE function for Mainframe exactly the way it works in LUW.

The downloading link is here:

Test Data Manager (TDM) Support Patches - Mainframe 6.0.04

U1027299_COB62.zip

U1027299_COB42.zip

 

On support page there has been added 5 examples of basic usage of this function.

For the example that was provided (Example: 374 Rue du Test should be mask as 111 Rue du Test), you can use as PARM 1= [0-9]   and PARM 2=1

This will generate the result that you need.