Splunk Search

How do I expand this multivalue field?

daniel333
Builder

All,

We are currently getting a log like this from our F5.

 xff="1.2.3.4, 4.3.2.1, 4.2.2.2, 9.8.7.1" 

I'd like to mvexpand it. I assumed I could just |mvexpand xff, but that doesn't not work.

Any idea how I would tackle this?

0 Karma

woodcock
Esteemed Legend

You have to make it a multivalued field first, like this:

... | makemv delim="," xff | mvexpand xff

sundareshr
Legend

Try this

... | eval x=split(xff, ",") | mvexpand x
0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...