• 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 😕