How to count the number of values?

[raghul725]

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.

[ITWhisperer]

Assuming alternativeIdValue is already a field, try this

| eval count=mvcount(split(alternativeIdValue,","))