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!
... View more