title: Jackson CSV parser chokes on comma separated value files if "," is in a field even if quoting with "
body: <p>The code:</p>
  
  <pre><code>package org.javautil.salesdata;
  import java.io.File;
  import java.io.IOException;
  import java.util.Map;
  
  import org.javautil.util.ListOfNameValue;
  
  import com.fasterxml.jackson.databind.MappingIterator;
  import com.fasterxml.jackson.dataformat.csv.CsvMapper;
  import com.fasterxml.jackson.dataformat.csv.CsvSchema;
  
  // https://github.com/FasterXML/jackson-dataformats-text/tree/master/csv
  public class Manufacturers {
      private static final String fileName= "src/main/resources/pdssr/manufacturers.csv";
  
      ListOfNameValue getManufacturers() throws IOException {
          ListOfNameValue lnv = new ListOfNameValue();
          File csvFile = new File(fileName);
          CsvMapper mapper = new CsvMapper();
  
          CsvSchema schema = CsvSchema.emptySchema().withHeader(); // use first row as header; otherwise defaults are fine
          MappingIterator&lt;Map&lt;String,String&gt;&gt; it = mapper.readerFor(Map.class)
             .with(schema)
             .readValues(csvFile);
          while (it.hasNext()) {
            Map&lt;String,String&gt; rowAsMap = it.next();
            System.out.println(rowAsMap);
          }
  
          return lnv;
  
      }
  
  }
  </code></pre>
  
  <p>The data:</p>
  
  <pre><code>"mfr_id","mfr_cd","mfr_name"
  "0000000020","F-L", "Frito-Lay"
  "0000000030","GM", "General Mills"
  "0000000040","HVEND", "Hershey Vending"
  "0000000050","HFUND", "Hershey Fund Raising"
  "0000000055","HCONC", "Hershey Concession"
  "0000000060","SNYDERS", "Snyder's of Hanover"
  "0000000080","KELLOGG", "Kellogg &amp; Keebler"
  "0000000115","KARS", "Kar Nut Product (Kar's)"
  "0000000135","MARS", "Mars Chocolate "
  "0000000145","POORE", "Inventure Group (Poore Brothers)"
  "0000000150","WOW", "WOW Foods"
  "0000000160","CADBURY", "Cadbury Adam USA, LLC"
  "0000000170","MONOGRAM", "Monogram Food"
  "0000000185","JUSTBORN", "Just Born"
  "0000000190","HOSTESS", "Hostess, Dolly Madison"
  "0000000210","SARALEE", "Sara Lee"
  </code></pre>
  
  <p>The exception is</p>
  
  <p>fasterxml.jackson.databind.exc.RuntimeJsonMappingException: Too many entries: expected at most 3 (value #3 (4 chars) "LLC"")</p>
  
  <p>I thought I would throw out my own CSV parser and adopt a supported project with more functionality, but most of them are far slower, just plain break or have examples all over the web that don't work with current release of the product.</p>