Test Data Manager

Expand all | Collapse all

Mainframe Flat file mask query

Jump to Best Answer
  • 1.  Mainframe Flat file mask query

    Posted 03-22-2018 04:12 PM

    Hi,

    Consider this scenario.

     

    I have a flat file. one field having with value as 'ABC12345', 'BVC23456' and 'GHT56789' etc.

    My expectation is to mask only numeric values, so i apply partmask function.

    the result would be 'ABC12334', 'BVC23232' and 'GHT34334'

     

    But i want to do mask like. if first 3 position of column value equal to 'ABC' then mask numeric value else leave as it is.

     

    Expectation result would be 'ABC12334', BVC23456' and 'GHT56789' etc. mask only those columns with having first 3 chars as 'ABC'.

     

    Unable to use where and like condition here. its taking whole column not like first 3 chars.

     

    its mainframe flat file for do masking.

     

    Please advise.



  • 2.  Re: Mainframe Flat file mask query
    Best Answer

    Posted 04-02-2018 01:44 PM

    You could a write a regex function for your requirement and then use REGEXPREPLACE to achieve the same.

     

    Masking Functions and Parameters - CA Test Data Manager - 4.4 - CA Technologies Documentation