2 Replies Latest reply on Jun 8, 2018 6:18 AM by Jusran Mawardi

    Find the first character in every word

    Jusran Mawardi

      hi all,

       

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

      Or

      Name : AMAZON WEB SERVICE

      Result : A***** W** S******

      Or

      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), " ", "*")

       

      Best