title: Issues importing csv data into R where the data contains additional commas
body: <p>I have a very large data set that for illustrative purposes looks something like the following.</p>
  
  <p>Cust_ID , Sales_Assistant  , Store <br>
  123     , Mary, Worthington, 22 <br>
  456     , Jack, Charles    , 42</p>
  
  <p>The real data has many more columns and millions of rows. I'm using the following code to import it into R but it is falling over because one or more of the columns has a comma in the data (see Sales_Assistant above).</p>
  
  <pre><code>df &lt;- read.csv("C:/dataextract.csv", header = TRUE , as.is = TRUE , sep = "," , na.strings = "NA" , quote = "" , fill = TRUE , dec = "." , allowEscapes = FALSE , row.names=NULL)
  </code></pre>
  
  <p>Adding row.names=NULL imported all the data but it split the Sales_Assistant column over two columns and threw all the other data out of alignment. If I run the code without this I get an error...</p>
  
  <p>Error in read.table(file = file, header = header, sep = sep, quote = quote, : duplicate 'row.names' are not allowed</p>
  
  <p>...and the data won't load.</p>
  
  <p>Can you think of a way around this that doesn't involve tackling the data at source, or opening it in a text editor? Is there a solution in R?</p>