Encrypt Data

[vardhan354]

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,

[gateleys]

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.

[chulett]

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.

[ray.wurlod]

You can easily mask with the Fmt() function.

Code: Select all

Fmt(InLink.SSN, "9R***-**-####")

[ray.wurlod]

You can easily mask with the Fmt() function.

Code: Select all

Fmt(InLink.SSN, "9R***-**-####")

[vardhan354]

I could achieve this by

'*****':Right (InLink.SSN, 4)

Once again, my thanks to all gurus........