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!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...