<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How to expand values for a field to multiple lines? in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/How-to-expand-values-for-a-field-to-multiple-lines/m-p/130187#M26779</link>
    <description>&lt;P&gt;You have to make it a &lt;CODE&gt;multivalued&lt;/CODE&gt; field first:&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;... | makemv delim=";" destination | mvexpand destination
&lt;/CODE&gt;&lt;/PRE&gt;</description>
    <pubDate>Mon, 20 Jul 2015 13:52:17 GMT</pubDate>
    <dc:creator>woodcock</dc:creator>
    <dc:date>2015-07-20T13:52:17Z</dc:date>
    <item>
      <title>How to expand values for a field to multiple lines?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/How-to-expand-values-for-a-field-to-multiple-lines/m-p/130186#M26778</link>
      <description>&lt;P&gt;Hi, &lt;/P&gt;

&lt;P&gt;I have a field that I want to expand to multiple lines (it's email transactions), so I have a CSV of:&lt;/P&gt;

&lt;P&gt;source,destination&lt;BR /&gt;
&lt;A href="mailto:joe@x.com"&gt;joe@x.com&lt;/A&gt;,&lt;A href="mailto:jane@y.com"&gt;jane@y.com&lt;/A&gt;&lt;BR /&gt;
&lt;A href="mailto:joe@x.com"&gt;joe@x.com&lt;/A&gt;,&lt;A href="mailto:jane@y.com"&gt;jane@y.com&lt;/A&gt;;&lt;A href="mailto:bill@y.com"&gt;bill@y.com&lt;/A&gt;&lt;/P&gt;

&lt;P&gt;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.&lt;/P&gt;

&lt;P&gt;Desired:&lt;BR /&gt;
source,destination&lt;BR /&gt;
&lt;A href="mailto:joe@x.com"&gt;joe@x.com&lt;/A&gt;,&lt;A href="mailto:jane@y.com"&gt;jane@y.com&lt;/A&gt;&lt;BR /&gt;
&lt;A href="mailto:joe@x.com"&gt;joe@x.com&lt;/A&gt;,&lt;A href="mailto:jane@y.com"&gt;jane@y.com&lt;/A&gt;&lt;BR /&gt;
&lt;A href="mailto:joe@x.com"&gt;joe@x.com&lt;/A&gt;,&lt;A href="mailto:bill@y.com"&gt;bill@y.com&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 20 Jul 2015 13:27:30 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/How-to-expand-values-for-a-field-to-multiple-lines/m-p/130186#M26778</guid>
      <dc:creator>adolan</dc:creator>
      <dc:date>2015-07-20T13:27:30Z</dc:date>
    </item>
    <item>
      <title>Re: How to expand values for a field to multiple lines?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/How-to-expand-values-for-a-field-to-multiple-lines/m-p/130187#M26779</link>
      <description>&lt;P&gt;You have to make it a &lt;CODE&gt;multivalued&lt;/CODE&gt; field first:&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;... | makemv delim=";" destination | mvexpand destination
&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Mon, 20 Jul 2015 13:52:17 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/How-to-expand-values-for-a-field-to-multiple-lines/m-p/130187#M26779</guid>
      <dc:creator>woodcock</dc:creator>
      <dc:date>2015-07-20T13:52:17Z</dc:date>
    </item>
  </channel>
</rss>

