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

       

       

      Thanks