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
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...