I need to do masking of my data in order to hide it from the target audience. Please find below existing table that I have right now. There are 3 columns in that table. SNO FIRSTNAME LASTNAME
1 JAYVADAN DARJI
2 KAPIL CHAUDHARY In the desired output, I want 4 columns with masking done as below. MASKED_NAME column would be an addition column the desired output. The desired output that I want SNO FIRSTNAME LASTNAME MASKED_NAME
1 JAYVADAN DARJI JXXXXXXN DXXXI
2 KAPIL CHAUDHARY KXXXL CXXXXXXXY Thanks a lot in advance.
... View more