title: Problems reading a CSV file into R with incomplete quotes, commas in character strings and unusual characters
body: <p>I'm trying to read in a large CSV file to R. The file is available at <a href="https://github.com/AidData-WM/public_datasets/releases/download/v3.0/AidDataCore_ResearchRelease_Level1_v3.0.zip" rel="nofollow noreferrer">https://github.com/AidData-WM/public_datasets/releases/download/v3.0/AidDataCore_ResearchRelease_Level1_v3.0.zip</a> and the READ ME states that encoding is UTF-8 and there should be 1,561,039 rows and 68 columns. I have tried several different ways to read in the data, but cannot get the full dataset to be read in. I think some problems might arise because: (i) there are incomplete quotations inside character strings, (ii) there are commas inside character strings and <code>sep=","</code> (so I can't use <code>quote=""</code> to deal with the quotations issue), and (iii) there are unusual characters such as arrows.</p>
  
  <p>Here are my various attempts to read the data and the resulting warnings:</p>
  
  <pre><code>aid &lt;- read.csv("AidDataCoreFull_ResearchRelease_Level1_v3.0.csv"),header=T, encoding="UTF-8")
  &gt; dim(aid)
  [1] 9960   68
  </code></pre>
  
  <p>Warning message:
  In scan(file = file, what = what, sep = sep, quote = quote, dec = dec,  :
    EOF within quoted string</p>
  
  <pre><code>aid &lt;- read.table("AidDataCoreFull_ResearchRelease_Level1_v3.0.csv"),header=T,sep=",",encoding="UTF-8")
  &gt; dim(aid)
  [1] 9960   68
  </code></pre>
  
  <p>Warning messages:
  1: In scan(file = file, what = what, sep = sep, quote = quote, dec = dec,  :
    EOF within quoted string
  2: In scan(file = file, what = what, sep = sep, quote = quote, dec = dec,  :
    number of items read is not a multiple of the number of columns</p>
  
  <pre><code>aid &lt;- read.csv("AidDataCoreFull_ResearchRelease_Level1_v3.0.csv"),header=F,skip=1,quote="",encoding="UTF-8")
  &gt; dim(aid)
  [1] 10956    72
  </code></pre>
  
  <p>No warning message this time, but no where near the full rows read in and now too many columns.</p>
  
  <pre><code>tx &lt;- readLines("AidDataCoreFull_ResearchRelease_Level1_v3.0.csv",encoding="utf-8",skipNul=T)
  &gt; length(tx)
  [1] 9961
  </code></pre>
  
  <p>Warning message:
  In readLines("AidDataCoreFull_ResearchRelease_Level1_v3.0.csv",  :
    incomplete final line found on 'AidDataCoreFull_ResearchRelease_Level1_v3.0.csv'</p>
  
  <p>I can't find a combination of commands that reads in the full CSV, and I can't open it in excel in order to view and try to tidy up the data. Any help would be greatly appreciated! </p>