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