XPATH with substring in the field for column to hash on

Products

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

Issue/Introduction

There is a requirement to mask Names stored in different table consistently. 

It is known that HASHLOV can be used to pick synthetic Names from seed list and there are few options to mask consistently like HASHING on column or without HASHING on column also if the source data is same it will mask consistently.

However in this case:

There is table A where there is First Name, Last Name & Full Name. Also there is a customer no which is appended with a character to denote if the customer is individual or corporate (for example 'I1234567', where 'I' is individual and '1234567' is customer no).Note that this table is storing data in XML document inside database column so First Name is having XPATH as XMLRECORD/row/c2 , Last Name is having XPATH as XMLRECORD/row/c3 ,  Full Name is having XPATH as XMLRECORD/row/c4 and customer no is having XPATH as XMLRECORD/row/c1

There is another table B where there is Full Name. Also, there is Account no which is 15 digit and it contains customer no from position 7 to 14 . Note that this table is storing data in XML document inside database column so Full Name is having XPATH as XMLRECORD/row/c2 and Account No XPATH as XMLRECORD/row/c27.
Now requirement is to HASH on customer number by doing SUBSTRING of customer number [something like SUBSTRING(XMLRECORD/row/c1, 2,7) ] in table A and to HASH on Account number by doing SUBSTRING of account number [something like SUBSTRING (XMLRECORD/row/c27, 7,7)]

Tried doing that but it is considering the 'SUBSTRING(XMLRECORD/row/c27, 7,7)' as a column and throws error that the column not found. 

Please note that if SUBSTRING is removed then it recognizes  the XPATH, means XMLRECORD/row/c1 is treated as customer no inside the XML document. 

Kindly suggest if there is already anyways of doing SUBSTRING on the COLUMN to HASH or if this can be considered for enhancement.

Environment

TDM 4.11.x

Cause

This has been identified as product enhancement request and has been implemented.

Resolution

The option to use an XPATH having SUBSTRING to be used in the field "column to hash on" has been implemented and delivered in below patch build of FDM:

https://ftp.broadcom.com/user/downloads/pub/TDM/FDM/FastDataMasker-4.11.46.0.zip

Steps to apply patch build:

https://knowledge.broadcom.com/external/article?articleId=10931