DSXchange

Guyz,

I need to encrypt the data coming from source(Database table) and load in to another Database table. The data is 'SSN'.The source has all the 9 digits displayed.The transformation is, I need to mask the first 5 digits and display the last four only....any advices.......


Thanks,

Unless you decide to write Basic code for AES, DES or the like, I would suggest you look at the possibility of calling these written as functions in languages like C/C++. You should find FIP compliant codes for the same in different languages. However, I don't know if they still have certain rules on some cryptographic codes if they are to be used outside of the USA.

Mask <> encrypt. If all you need to do is mask the first five digits so it looks something like this:

***-**-1234

Then just substring off the last four digits and concatenate that with the 'mask' for the first 5. Just don't expect to be able to 'unmask' it later.

You can easily mask with the Fmt() function.

You can easily mask with the Fmt() function.