Hello all,
I have a special demand to mask code postal values within an Oracle table. I tried to make a SM algorithm to answer, without success 'til now :(
Here are the specifications :
- The field to mask is a varchar2(5) column with only "number" between "01000" and "99999"
- the rules to mask this field are :
1 - Every numbers after the 2 firsts ones are masked to zero
2 - Values above 99000 must be exclude (never masked)
So for exemple
01234 -> 01000
12345 -> 12000
66666 -> 66000
99123 -> 99123 (not masked)
99666 -> 99666 (not masked)
etc.
Is it possible with the masking engine only ? (without add triggers in the database, for example)
Regards,
Nicolas
PS : I was able to make a SM algo to mask everthing after the 2 firsts char. (thank for community help :
https://community.delphix.com/delphix/topics/masking-with-zero), but i can't exclude the 99xxx codes
#Masking