@Dontik wrote: 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!
And WHERE is this to be masked?
If in output report pages then possibly formats could work. But if you want to limit other users of your data sets you may have significant issues if this is for security purposes.
I think you may be looking to make a series of formats but some issues arise such as is the data static or changing periodically. A one time use is not that difficult but details will arise if you will be continuing to add to the document number or postal codes.
Does the "name" masking need to create a "unique" value? How many characters? Minimum or Maximum length?
... View more