title: Import a csv file into R containing multiple columns in one column?
body: <p>I have a csv file. The file contains the data separated by spaces in single column. The problem doesn't end here as there are certain places where extra column is present in some row. I want to split the data based(create column) based on the spaces. The data set is very huge so I don;t want to that manually. Please look at the sample data and let me know how can i import the file in desired format.</p>
  
  <p>Please find below the sample data: </p>
  
  <p>First row:</p>
  
  <pre><code>"3000 2010-09-10 01:06:10.144132-05 2010-09-10 01:06:10.018-05 353 Location No_en 5860    
   ""locx""=&gt;""963"""  "locy"=&gt;"3998"  "flew_id"=&gt;"Campus&gt;center&gt;Layout Floor"
  </code></pre>
  
  <p>Most of the rows are like this but there are places where we have rows as mentioned below:</p>
  
  <p>Second Row:</p>
  
  <pre><code>"3000 2010-09-10 01:06:10.129147-05 2010-09-10 01:06:10.015-05  353 Location Unit09 0085    ""locx""=&gt;""873""" "locy"=&gt;"30344" "con"=&gt;"67676" "flew_Id"=&gt;"Campus&gt;Center&gt;Layout Floor"
  </code></pre>
  
  <p>Here we have one extra column as con. which is not there in the other rows. Any thoughts??</p>