Splunk Search

makemv not working

brinley
Path Finder

I have the following single-value field (that really should be a multi-value field):

puppy_name="Spot Dexter Jake"

It really should be a multivalue field, like ...

puppy_name="Spot" "Dexter" "Jack"

Here is what I have tried:

index=puppies | makemv puppy_name delim=" "

Unfortunately that is not working. I can tell because when when I expand an event with the field puppy_name and hover over puppy_name's value in the dropdown, "Spot Dexter Jack" is still a single unit. What am I doing wrong?

0 Karma
1 Solution

brinley
Path Finder

I figured it out. I was using the wrong delim. The delim between each puppy name appeared to be a space in the search results but it was really a newline. Passing delim="\n" to makemv didn't work, so I just converted the newlines into a bar, "|", and then used the bar as the delim.

Final query:

index="puppies" | eval new_puppy_name=puppy_name | rex mode=sed field="new_puppy_name" "s/\n/|/g"| makemv new_puppy_name delim="|"

View solution in original post

0 Karma

brinley
Path Finder

I figured it out. I was using the wrong delim. The delim between each puppy name appeared to be a space in the search results but it was really a newline. Passing delim="\n" to makemv didn't work, so I just converted the newlines into a bar, "|", and then used the bar as the delim.

Final query:

index="puppies" | eval new_puppy_name=puppy_name | rex mode=sed field="new_puppy_name" "s/\n/|/g"| makemv new_puppy_name delim="|"
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!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...