title: Loading csv in ElasticSearch using logstash
body: <p>I have a csv in which one column may contain multi-line values. </p>
  
  <pre><code>ID,Name,Address
  1, ABC, "Line 1
  Line 2
  Line 3"
  </code></pre>
  
  <p>The data written above as per CSV standard is one record (to my knowledge). </p>
  
  <p>I have following filter for logstash </p>
  
  <pre><code>filter {
    csv {
        separator =&gt; ","
        quote_char =&gt; "\""
       columns =&gt; ["ID","Name", "Address"]
    }
  }
  output {
     elasticsearch {
       host =&gt; "localhost"
       port =&gt; "9200"
       index =&gt; "TestData"
       protocol =&gt; "http"
    }
  stdout {}
  }
  </code></pre>
  
  <p>But when I execute it, it creates three records. (All are wrong in principle as first one contains two column data ID and Name and partial data for Address and next two records contain Line 2 and Line 3 but no ID and Name </p>
  
  <p>How can I fix this? Am I missing something in the file parsing?</p>