thanks for the reply!
I google split function and found the following function that gets me on my way but I'm having trouble trimming it so I only get the values I need. I'm also having trouble removing the "&". Note that this string is dynamic so it can be "CHILD=1625=0n=1==3&ADULT=1900=1j=1==1" or "ADULT=1075=0r=12==4" or ADULT=1100=2J=4==1&SENIOR=1000=2K=4==1", etc.
I'm wondering if I need an IIF staments to account for the "&"
=Join(Split(Fields!Tix_Price.Value,"="),", ")
result: CHILD, 900, A1, 3, , 1&SENIOR, 900, A4, 3, , 2
would like it to look like CHILD, SENIOR
Still not sure how to remove the extra values and only keep the two I need 😕