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)