hi all,

I want to count the below records to two single records (based on cts and ibm). Each string should repeated only once

finance/economy/boy/cts=12

finance/economy/girl/cts=3

finance/economy/boy/cts=6

education/economy/boy/cts=2

commerce/non-economy/girl/cts=3

finance/economy/boy/cts=6

finance/economy/girl/ibm=2

finance/economy/boy/ibm=4

Output should be like this "education/finance/commerce/economy/non-economy/boy/girl cts=32"

"finance/economy/boy/girl/ibm=6"

Please note that data string are frequently changed at respective to the left and right of forward slash and record are in dynamic range.