2 Replies Latest reply: Nov 1, 2018 1:49 PM by Jeshwanth Boragani RSS

    Remove everything after 2nd space

    Matt Milian

      I feel this is an easy question, but cannot seem to figure out the answer.  How would you get rid of all the characters after the second space?


      [Field Name]


      JP Smith (Micheals) Market

      T Warner Market

      A Phillips (Hounds) Farms

      Kelley Williams Tower


      So it would look like this


      [Field Name]


      JP Smith

      T Warner

      A Phillips

      Kelley Williams