Support for REGEXSUBSTR, HASHLOV for COMBINEVALS - need an extra field added to support a specific column delimiter field.

Document ID : KB000009187
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Requirements have come in regarding a set of data that needs to be masked that Fast Data Masker does not currently cover.  Due to how the data was generated, there are two delimiters used to distinguish between fields and sub fields.  For example, here is a line of raw data (obfuscated for the most part):

9100 HWY 114^TS BSX 72^NEW YORK^TN^38374^WSA  

Please note that the pipe "|" symbol is used to distinguish between fields and the carat "^" is used as a delimiter within the fields.  How can we mask only "9100 HWY 114" ?

Environment:
FDM in TDM 4.4 GA
Cause:

Need new software to accomplish this.

Resolution:

In the mapper there are 2 new fields, From Occurrence and To Occurrence. 

DelimiterEnhancement.png

The entries for these should be in the form of number of occurrence (character to test). For example:

The initial string is:

9100 HWY 114^TS BSX 72^NEW YORK^TN^38374^WSA 

To mask 9100 HWY 114, the first occurrence is left blank and the to occurrence is 1(^). 

If you wanted to mask NEW YORK, the values are:

FROM OCCURENCE : 2(^) 
TO OCCURRENCE: 3(^) 


Please contact Support for the version of Fast Data Masker that contains this new functionality (FastDataMasker-4.7.230.0.zip or greater).  Please note that it should be in the next GA after TDM 4.4.  As is common practice, please verify with Support that this fix made it into the next GA after TDM 4.4.