How to expand values for a field to multiple lines?

[adolan]

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

[woodcock]

You have to make it a multivalued field first:

... | makemv delim=";" destination | mvexpand destination