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
[email protected],[email protected]
[email protected],[email protected];[email protected]

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
[email protected],[email protected]
[email protected],[email protected]
[email protected],[email protected]

[woodcock]

You have to make it a multivalued field first:

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