5 Replies Latest reply on Jun 11, 2017 5:48 PM by beverly

    Triming characters left and right from word

    laguna92651

      I have the text string below, I would like to trim the characters left and right of the string to end up with Red Apples. I started an expression using Middle() but things kept getting longer and longer, figured there must be a shorter way. All the characters will be the same except for the text represented by Red Apples. The text Red Apples will change.

       

      Starting string

      "name":"Red Apples"}

       

      Ending string

      Red Apples