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.
Bookmarks