<?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: What is the default delimiter for multivalue fields in Splunk when exporting a table to a CSV file? in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/What-is-the-default-delimiter-for-multivalue-fields-in-Splunk/m-p/151637#M30854</link>
    <description>&lt;P&gt;The delimiters used by makemv etc are instructions on how to take a string and identify multiple values within it.  In-memory, there simply multiple string values for the field, without any delimeters. &lt;/P&gt;

&lt;P&gt;When we serialize the multivalue fields to csv, typically there are two reprsentations, one representation acts as a hint that there is a multivalue field, and the other representation is newline-delimited.  This is true for data passed to a python search command, or when using the &lt;CODE&gt;|outputcsv&lt;/CODE&gt; command.  I'm not familiar with what you get when using the in-gui "export" feature with multivalue fields.&lt;/P&gt;

&lt;P&gt;In the current implementation, the system actually tracks a single-value string and a multi-value set of values for a field that is multivalue, so we may provide the single-value string when exporting even though we will ignore it.  (If relevant, this is an implementation wart which will eventually go away.)  &lt;/P&gt;</description>
    <pubDate>Sat, 04 Oct 2014 11:48:14 GMT</pubDate>
    <dc:creator>jrodman</dc:creator>
    <dc:date>2014-10-04T11:48:14Z</dc:date>
    <item>
      <title>What is the default delimiter for multivalue fields in Splunk when exporting a table to a CSV file?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/What-is-the-default-delimiter-for-multivalue-fields-in-Splunk/m-p/151636#M30853</link>
      <description>&lt;P&gt;Hi guys,&lt;/P&gt;

&lt;P&gt;i just want to know the default delimiter for multivalue field in splunk&lt;BR /&gt;
when i export a table to a csv.file&lt;BR /&gt;
if the multivalue field is splunk generated , i can see the values are line by line in its csv cell&lt;BR /&gt;
but if it generated manually , such as the following : &lt;/P&gt;

&lt;P&gt;| eval cfxA=cfsnA."///".cfmnA."///".cfszA&lt;BR /&gt;
| makemv delim="///" cfxA&lt;/P&gt;

&lt;P&gt;i can only see the values are all in the same line and delimited by "///"&lt;BR /&gt;
who can tell me which delimiter could let them displayed line by line , please ?&lt;/P&gt;</description>
      <pubDate>Sat, 04 Oct 2014 02:52:27 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/What-is-the-default-delimiter-for-multivalue-fields-in-Splunk/m-p/151636#M30853</guid>
      <dc:creator>gfs2277</dc:creator>
      <dc:date>2014-10-04T02:52:27Z</dc:date>
    </item>
    <item>
      <title>Re: What is the default delimiter for multivalue fields in Splunk when exporting a table to a CSV file?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/What-is-the-default-delimiter-for-multivalue-fields-in-Splunk/m-p/151637#M30854</link>
      <description>&lt;P&gt;The delimiters used by makemv etc are instructions on how to take a string and identify multiple values within it.  In-memory, there simply multiple string values for the field, without any delimeters. &lt;/P&gt;

&lt;P&gt;When we serialize the multivalue fields to csv, typically there are two reprsentations, one representation acts as a hint that there is a multivalue field, and the other representation is newline-delimited.  This is true for data passed to a python search command, or when using the &lt;CODE&gt;|outputcsv&lt;/CODE&gt; command.  I'm not familiar with what you get when using the in-gui "export" feature with multivalue fields.&lt;/P&gt;

&lt;P&gt;In the current implementation, the system actually tracks a single-value string and a multi-value set of values for a field that is multivalue, so we may provide the single-value string when exporting even though we will ignore it.  (If relevant, this is an implementation wart which will eventually go away.)  &lt;/P&gt;</description>
      <pubDate>Sat, 04 Oct 2014 11:48:14 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/What-is-the-default-delimiter-for-multivalue-fields-in-Splunk/m-p/151637#M30854</guid>
      <dc:creator>jrodman</dc:creator>
      <dc:date>2014-10-04T11:48:14Z</dc:date>
    </item>
  </channel>
</rss>

