title: EOF within quoted string
body: <p>I have a file with about 350,000 rows.
  I am using </p>
  
  <pre><code>S.longtermtest="COKE32500.csv"
  x=read.csv(S.longtermtest, row.names=NULL)
  </code></pre>
  
  <p>to read it to x. </p>
  
  <p>The data is not properly specified/formatted. Below is an example where in the record with id="1020608401", there are extra quotation marks and so read.csv does not handle it the way I need. Is there a way to read in this kind of data and whenever there appear to be more than 7 fields, to just skip that record?</p>
  
  <p>The 7 field names are </p>
  
  <pre><code>"Tweet ID","Date","Username","Text","Location","Followings","Followers"
  </code></pre>
  
  <p>Here is a sample of the data:</p>
  
  <pre><code>"Tweet ID","Date","Username","Text","Location","Followings","Followers"
  "1020580305","09/26/2012 17:01:00","LoudpackMariee","RT @marvelousbby: @LaLaaKors no you just say too much on twitter","Niggas wit coke","0","0"
  "1020591756","09/26/2012 17:22:46","Sofia_Torrez","I must give up Coke. @AnahiMarcial http://t.co/O9QyXGjg","San Diego, California","0","0"
  "1020594942","09/26/2012 17:24:22","PaterGH13","Con mi paisana y amiga @MireiaCarrillo  de GH 12 tomando una coke en los madriles) un gustazo verte!! Muuuuak http://t.co/V2QFqi08","Barcelona, España","0","0"
  "1020595525","09/26/2012 17:24:40","WP2_DotCom","RT @UNADining: Stop by the GUC today and enter the drawing for a chance to win a coke bean bag http://t.co/URCtK1p9","Florence, Alabama","0","0"
  "1020600160","09/26/2012 17:42:30","RadicalWizard_","I always block accounts like this, but this has got to be the best spam bot bio I've ever encountered. Str8 2 the point http://t.co/ICOD3zuI","Sniffing lines of coke","0","0"
  "1020600792","09/26/2012 17:42:49","LexDLutor","coke boyz _ instru (prod by Lex Lut'Or) by @LexDLutor via #soundcloud http://t.co/5WW5i1uT","Bruxelles Belgique","0","0"
  "1020602605","09/26/2012 17:43:45","LoudpackMariee","","RT @PardonMyLips: Forreal. RT @intoxicatedBia: You hip RT “@LoudpackMariee: This bitch tells her entire life story on twitter. ENiggas wit coke","0","0"
  "1020608358","09/26/2012 17:46:40","SimplySophie","RT @BreezysLullaby: i asked for a coke not strawberry milkshake @mcdonalds!!!! http://t.co/DwC8l6iZ","Liverpool","0","0"
  "1020608401","09/26/2012 17:46:41","danielzol4nski","RT @heymarkey: "@wezhopwood: A Cinema was robbed last night of £754, thieves took a bag of malteasers, a pick n mix and a large coke." h ...","Krim+Azealia's block list (UK)","0","0"
  "1020644783","09/26/2012 19:00:54","klierlyshirley","Cheery coke? LOL http://t.co/bGMg2cAV","the hundred acre woods.","0","0"
  "1020660546","09/26/2012 19:24:50","midsummerfrenzy","Cherry Coke is the best. http://t.co/7xzlvkOe","Tulsa, OK, USA","0","0"
  </code></pre>