2 Replies Latest reply on May 2, 2018 8:22 AM by Danielle Johns

    Find and Replace - Tableau Prep, common characters replacement.

    Danielle Johns

      Hello everyone,


      I'm pretty new to Prep.


      Basically I have a field with some rows beginning with the same 4 Characters -'zzz_' .


      Example Tablaru.png



      This pattern does not repeat all the way through on every row. For example, only the last few rows have 'zzz_' at the front, and the other 20 or so are perfectly fine as they are.


      How can I delete the first 4 characters in order to homogenize the data in my field? Sitting through and deleting them manually is laborious and i'm convinced there is a better way to do this....

      I have tried different techniques, but I don't think they are giving the desired results. My intention is to then join this homogenised field with another worksheet.


      I have attached an example flow to this question too.


      Thank you!!