Getting Data In

How to expand values for a field to multiple lines?

adolan
New Member

Hi,

I have a field that I want to expand to multiple lines (it's email transactions), so I have a CSV of:

source,destination
joe@x.com,jane@y.com
joe@x.com,jane@y.com;bill@y.com

I want to expand this to 3 lines, which I think mvexpand should do, but it doesn't work and I can't figure out to tell it what the delimiter (";") is.

Desired:
source,destination
joe@x.com,jane@y.com
joe@x.com,jane@y.com
joe@x.com,bill@y.com

0 Karma

woodcock
Esteemed Legend

You have to make it a multivalued field first:

... | makemv delim=";" destination | mvexpand destination
Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...