title: My CSV data is getting truncated or concatenated
body: <p>I can view data in my CSV file and it looks pretty normal.</p>
  
  <p><a href="https://i.stack.imgur.com/jOf1A.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jOf1A.jpg" alt="enter image description here"></a></p>
  
  <p>However, when I try to import the data this way, all headers get concatenated together.</p>
  
  <pre><code>ann2012 &lt;- read.csv2("C:\\Users\\annualsinglefile.csv", header = TRUE)
  </code></pre>
  
  <p>When I try to import the data this way, the headers appear fine, but the leading zeros in the first column are all dropping off...even though they are in the CSV file.</p>
  
  <pre><code>ann2012 &lt;- read.table("C:\\Users\\annualsinglefile.csv", header = TRUE, 
  sep = ",")
  </code></pre>
  
  <p>I tried a few different ways to add a leading zero (current length is 4 characters and it needs to be 5 characters).  </p>
  
  <pre><code>library(stringr)
  str_pad(ann2012$fips, 5, pad = "0")
  
  
  str_pad(x, 8, pad = "0")
  
  
  sprintf("%05s", 1)
  
  
  library(stringi)
  stri_pad_left(str=ann2012$fips, 5, pad="0")
  </code></pre>
  
  <p>It seems like that just changes the format of the data, but the underlying data does not change at all.  How can I update the first column to have leading zeros, or just import the data as-is, and preserve the leading zeros?  Thanks.</p>