Hi
As stated in the title, how to mask/encrypt (using a certain pattern/set of rules) a column and be able to unmask/decrypt it later?
For example:
Name - needs to contains letters and no special characters like !@'j etc. So I would like to change a name like John to something that could possibly be a name, i.e. a set of letters.
Postal code - needs to follow a certain pattern NN-NNN, so 2 digits, a dash and 4 more digits.
Document numer - needs to follow a certain pattern LLNNNNN, so 2 letters and 5 digits. Masked value also needs to be unique.
But that's just the beginning, there should also be a way to reverse it, unmask it.
Any ideas?
Thank you in advance!