Splunk Dev

How to count the number of values?

raghul725
Explorer

Hello

I would like to count the number of values every time the search matches the string  alternativeIdValue- i.e. after the = count the values separated by ,

 

alternativeIdValue=IE778898,WX888889,IS89657578,XS76575889.............................................

 

The length of each value can be different and  the only common pattern is they are separated by comma and they start with an alphabet.

 

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Assuming alternativeIdValue is already a field, try this

| eval count=mvcount(split(alternativeIdValue,","))
0 Karma
Get Updates on the Splunk Community!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...