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
You have to make it a multivalued
field first:
... | makemv delim=";" destination | mvexpand destination