title: read csv in R, bad formatting?
body: <p>I've got the following csv-file:</p>
  
  <pre><code>"ID,""oldid"",""country"",""side_a"",""densdiff"
  "10,32,""Afghanistan"",""Afghanistan"",""Various organizations"
  </code></pre>
  
  <p>During the exercises we got a few csv-files that where always formattet "clear" e.g.</p>
  
  <pre><code>"ID","oldid","country" ...
  "10","32","Afghanistan" ...
  </code></pre>
  
  <p>I figured out, that the separator is a "," but it is sometimes in a string ("ID,"), sometimes there is no separator 
  (looks like : 
      "intden"",""densdiff"""
  so I don't know what to do with the last two quotes)  </p>
  
  <p>I didn't found a good website that explains a "mixed-csv-formatted" input for R. </p>
  
  <p>Edit: Here is the complete header and the first line:</p>
  
  <pre><code>"ID,""oldid"",""country"",""side_a"",""side_b"",""cow"",""incompatibility"",""terr"",""begin"",""end"",""type"",""identity"",""radius"",""confarea"",""landarea"",""confland"",""rel_scope"",""distance"",""maxdist"",""mindist"",""disper"",""pop2000"",""resource"",""mountain"",""forest"",""border"",""mindisx"",""lnmndist"",""confarex"",""ln_abs_scope"",""ln_land_area"",""lnpop"",""lnconpro"",""duration"",""distx"",""location"",""mountx"",""frstx"",""lnmountx"",""lnfrstx"",""diamond"",""diadist"",""gold"",""golddist"",""oil"",""oildist"",""roadpave"",""roadtot"",""pavetot"",""paveland"",""roadland"",""disxsqr"",""mndisxsq"",""stabilit"",""rulelaw"",""nocorrup"",""lnd100km"",""pop100km"",""lnd100cr"",""pop100cr"",""landlock"",""ciffob95"",""coastden"",""intden"",""densdiff"""
  </code></pre>
  
  <p>And the next line:</p>
  
  <pre><code>"10,32,""Afghanistan"",""Afghanistan"",""Various organizations"",700,2,"""",1978,2000,3,1,400,500,652,77,77,122,522,0,0.509999990463257,27,0,66,3,1,1,0,500,6.21460819244385,6.4800443649292,3.29583692550659,0.959037899971008,23,122,4.80402088165283,66,3,4.18965482711792,1.0986123085022,0,NA,0,NA,0,NA,2.79999995231628,21,13.3333330154419,0.429447859525681,3.22085881233215,14884,1,NA,NA,NA,0,0,0,0,1,NA,0,36,-36"
  </code></pre>
  
  <p>Edit 2:
  After a lot of trubbleshooting I downloaded only the csv-file and it is clean now. I will do a comment after questioning my lecturer. Thanks for all the help :)</p>