AnsweredAssumed Answered

Triming characters left and right from word

Question asked by laguna92651 on Jun 11, 2017
Latest reply on Jun 11, 2017 by beverly

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

Outcomes