I would like to split a column of names, into two columns by the first white space. In this example, we have two white spaces, but could be more.
a <- "Lucero del Alba"
The expected outcome:
> c
[1] "Lucero" "del Alba"
Approach 1, wrong because is deleating "Lucero del" :
> strsplit("Lucero del Alba", "^.+ ")
[[1]]
[1] "" "Alba"
Approach 2, good, but how do I get the rest?
> strsplit("Lucero del Alba", " .+$")
[[1]]
[1] "Lucero"