FDM How to mask a value inside a column with multiple values

Products

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

Issue/Introduction

Hello,
I have a set of table(s) that is required for masking.
The masking exercise has some specific requirements.

Take the sample I have provided
Dummy_name
002696368 ONTARIO INC. O/A REYNO

when masked, and applying the exclusions (values not to be masked), it would look like this:
006921345 ONTARIO INC. O/A KGDYW

Only the value REYNO is masked and the result is KGDYW. 
The other values 'ONTARIO', 'INC.', 'O/A' are excluded from masking.

How can this be accomplished?

 

Environment

FRM 4.9.X

Resolution

Option1:
If the position is fixed, then there are masking routines where you can specify the starting positions such as formatencrypt1.  

Options2:
If it is always the last value in the string you could use positionmask, starting from the right...

Option3:
you can use the Occurrence option that is at the bottom of the screen when defining a masking function.  With the occurrence option/parameter you specify the delimiter and the occurrence where you want to start.  So for your example, you would specify 3( ).    space being the delimiter.  

Option4:
if you want to formatencrypt the first token and the fifth token and space is a delimiter  then you  use FORMATENCRYPT1DELIMITER=SPACE1,5

Note:
Space is a special case where we use SPACE as the keyword. If you want to mask the second third and fourth token with a pipe as delimiter use FORMATENCRYPT1DELIMITER=|2-4

 

Unfortunately, if the data is not well structured or uniform and some way that the above can be used then this will not be possible with the current version.

When I looked at the same CSV your provided it did not look as if the data was variable, not well structured, but I may be mistaken.