We need to mask the following query. kindly assist us for the same.
for c_id column , we need to concat (branch column's first letter,acc_code,c_srv), need assistance us on how to substring the first letter of branch column to do concatenation with other columns( acc_code,c_srv).
Release : 4.8
Component : CA Test Data Manager
After further review of the file and your requirement, we can not combine substring and concat functions on flat file masking.
This can be achievable for data in database tables by using SQLFUNCTION masking function. As this function will not work for flat file masking, we can not concat multiple columns along with substring.