title: Splitting Columns in R based on space
body: <p>I have a Location Column which looks like the following-</p>
  
  <pre><code>   Location 
     San Jose CA
     Santa Clara CA
  </code></pre>
  
  <p>I want to split into two columns. I'm using the separate function from tidyr, but giving the sep argument as " " gives me the following-</p>
  
  <pre><code>  City  State
    San   Jose
    Santa Clara
  </code></pre>
  
  <p>How can I split the column based on only the second space?</p>
  
  <pre><code>structure(list(Location = c("San Jose CA", "Santa Clara CA")),
            .Names = "Location", class = "data.frame", row.names = c(NA, -2L))
  </code></pre>