title: What parameters does Excel use to read in CSV files, and how can it be adapted to R?
body: <p>I have a CSV file which mixes quoting and unquoting that gives R problems when trying to read it in. The issue arises with commas within the quotes, it delimits on these but I want them ignored. When viewing the CSV in Excel, it manages it perfectly and understands where to break. Is there a way these settings can be viewed/translated to R?</p>
  
  <p>Here is the <a href="https://toppgene.cchmc.org/ResultsMatrix?userdata_id=6e2fe68a-0021-4485-9519-96cc27e73183" rel="nofollow">link</a> to download the file in question, it's a set of gene ontologies and their associated terms and whether or not the gene is part of it (0 or 1). It should be 4 columns of text, 1 column of pValues, and 50 columns of 0/1.</p>
  
  <p>I've tried reading it into R with <code>read.table(file, quote="\"", sep=",", row.names=NULL)</code>, but the values from Category, Name, Verbose ID spill into the pValue and then affect the counts data. Then entire rows of data may be put into one cell until another misinterpreted delimiter arises.</p>
  
  <p>Here's an example problem line, with some of the last columns of 0/1 redacted for length.</p>
  
  <pre><code>"Pubmed","Expression of epidermal growth factors, erbBs, in the nasal mucosa of patients with chronic hypertrophic rhinitis.","22327010","pubmed_22327010_Expression_of_epidermal_growth_factors,_erbBs,_i...",0.005837270080633278,0,0,0,0,0,1,0,...
  </code></pre>