3 Replies Latest reply: Feb 1, 2018 8:22 AM by Ali Hijazi RSS

    Search string based on a character and remove or scramble

    Twan Peters

      In my dashboard i'm loading a field that can contain email addresses, i would like to remove or scramble these email addresses.

       

      Example:

       

      Field
      info@test.nl
      New York
      Belgium
      Honda
      Qlikview

       

      Desired output:

       

      Field
      NULL or wlegh#)*%_
      New York
      Belgium
      Honda
      Qlikview

       

      Hence, in my script i think i first need to search on values in my Field that can contain an @, and after that remove it, or scramble it.

       

      Any ideas on how to do this?