3 Replies Latest reply on Sep 13, 2018 3:35 PM by Joshua Milligan

    Can a known substring be removed from a string?

    George Brooks

      If I have the string


      BIGSTRING="The quick brown fox jumps (over the lazy fence)."


      I know how to extract

      SMALLSTRING="(over the lazy fence)" from BIGSTRING


      How do I make

      RESULTSTRING="The quick brown fox jumps "?


      Using Tableau Prep