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