How to obscure data using Calculated fields?

Question & Answer
1

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**.

2

Possible solution - however in this case you need to know the max length of string in the col you want to obscure.

image (3)
image (3)1207×582 47.1 KB

1 Like
3

I would recommend that you just keep each string a fixed length so as to obscure them more effectively. Use two different calculated fields:

  1. c_city_first2: substring(City,1,2)
  2. c_city_masked: concat(c_city_first2,‘*****’)
1 Like