Splunk Search

Strange behavior of values function

emzed
Path Finder

Is there anyone who can explain me strange behaivor of "values" function. I created statistic by "stats" with "values" function and it returned mvfield as I expected, but there was in one line where values in mvfield were separated by comma not by newline. I attached a screenshot of this.

I tested on Splunk 8.2.7 and 9.0.0.

If I replace colon in field "source" by something else, the behavior change.

Search_ Splunk_8.2.7.png

Labels (1)
Tags (3)
0 Karma

PickleRick
SplunkTrust
SplunkTrust

Yes, there is some problem with displaying mvfields and it manifests itself from time to time in this weird way in the ui.

Try adding something like

| eval c=mvcount(data) | eval first=mvindex(data,1)

It should still work properly, returning a count of 3 and your first value from that field.

0 Karma

emzed
Path Finder

Thank you for your reply. I think it is not for first time when I have seen it. There must be some small bug. I know that field is still mvfield and it behaves like that.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

(: is the start of a construct in regex so perhaps this is the source of the issue. Try changing the replace to use (\:

0 Karma

emzed
Path Finder

I tried the change and It does not help. You can se on first screenshot.Search_ Splunk_8.2.7_1.png

You were right that the trigger could be the colon. If I remove the ":" from field and calculate the stat then all mvfield displayed the same way.
Search_ Splunk_8.2.7_2.png

It doesn't completely solve my problem. 

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...

Design, Compete, Win: Submit Your Best Splunk Dashboards for a .conf26 Pass

Hello Splunkers,  We’re excited to kick off a Splunk Dashboard contest! We know that dashboards are a primary ...

May 2026 Splunk Expert Sessions: Security & Observability

Level Up Your Operations: May 2026 Splunk Expert Sessions Whether you are refining your security posture or ...