I want remove everything after "-" and any digit for example -1,-2,-3...-9,-0  I'm using rex function but not getting desired output. current data Desired o/p splunk.server-1.9.0.CLIEN-server-38444 splunk.server abcd-available.server-7.0.0.RETCAR-server-75344 abcd-available.server ... View more

I have 2 columns 1 has application name another has number of  instances . I want to remove duplicate application name but same time instance count should show addition of all the instance for the same application name. I'm using dedup but instance count addition need some other logic.    APPNAME INSTANCECOUNT sap 2 oracle  4 sap  2 git 2 oracle 4     ... View more