0 Replies Latest reply: Jun 30, 2016 6:25 AM by kapil rathore RSS

    How to split a string and rejoin upon match, in pivot expression.

    kapil rathore

      Q - How to split a string and rejoin upon match, in pivot expression.

       

      i have a field 'Enhancements' which holds Data in the following Format (comma delimited)-

       

      RC1, RC15, FRX, RC89, RF6, RF66, RC234, RCX, RCY

       

      in a pivot expression i wanted to Display fields which matches to RC followed by Number  (comma delimited) as -

       

      RC1, RC15, RC89, RC234



      How to write an expression to achieve this requirement. (basically i wanted to split the string using delimiter and want to join them back if the each splitted value matched to the condition)