I want to mask the sensitive data, so when users download the data, they sensitive information is masked. Let say I want to masking the name:
Name : TABLEAU SOFTWARE
Result : T****** S*******
Name : AMAZON WEB SERVICE
Result : A***** W** S******
Name : APPLE
Result : A****
the field has no specific how many spaces
the question is, how to find the first character in every word? so I can get the result as expected.
Note: for character "*", I try to use SPACE(N), and REPLACE(SPACE(N), " ", "*")
Please try my solution below
Hope this helps
thanks Zhouyi Zhang
what if I want to show 3 character in every word.
Name: TABLEAU SOFTWARE
Result: TAB**** SOF*****
can I add some parameter in that regexp?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...