For example, instead of showing field directly I want to show show first two character and not the rest of the field. For example in case of name it would be instead of showing John - i want to show Jo**.
Possible solution - however in this case you need to know the max length of string in the col you want to obscure.
I would recommend that you just keep each string a fixed length so as to obscure them more effectively. Use two different calculated fields:
- c_city_first2: substring(City,1,2)
- c_city_masked: concat(c_city_first2,‘*****’)