https://community.splunk.com/t5/Splunk-Dev/How-to-count-the-number-of-values/m-p/644035#M11059 <P>Hello</P> <P>I would like to count the number of values every time the search matches the string&nbsp; alternativeIdValue- i.e. after the = count the values separated by ,</P> <P>&nbsp;</P> <P>alternativeIdValue=IE778898,WX888889,IS89657578,XS76575889.............................................</P> <P>&nbsp;</P> <P>The length of each value can be different and&nbsp; the only common pattern is they are separated by comma and they start with an alphabet.</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 22 May 2023 12:49:26 GMT raghul725 2023-05-22T12:49:26Z https://community.splunk.com/t5/Splunk-Dev/How-to-count-the-number-of-values/m-p/644035#M11059 <P>Hello</P> <P>I would like to count the number of values every time the search matches the string&nbsp; alternativeIdValue- i.e. after the = count the values separated by ,</P> <P>&nbsp;</P> <P>alternativeIdValue=IE778898,WX888889,IS89657578,XS76575889.............................................</P> <P>&nbsp;</P> <P>The length of each value can be different and&nbsp; the only common pattern is they are separated by comma and they start with an alphabet.</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 22 May 2023 12:49:26 GMT https://community.splunk.com/t5/Splunk-Dev/How-to-count-the-number-of-values/m-p/644035#M11059 raghul725 2023-05-22T12:49:26Z https://community.splunk.com/t5/Splunk-Dev/How-to-count-the-number-of-values/m-p/644036#M11060 <P>Assuming alternativeIdValue is already a field, try this</P><LI-CODE lang="markup">| eval count=mvcount(split(alternativeIdValue,","))</LI-CODE> Sun, 21 May 2023 14:44:53 GMT https://community.splunk.com/t5/Splunk-Dev/How-to-count-the-number-of-values/m-p/644036#M11060 ITWhisperer 2023-05-21T14:44:53Z