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?
FRM 4.9.X
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.