Use gsub to delete the whole line before the first space in R

Question

I have a data frame like this:

name weight r apple 0.5 y pear 0.4 y cherry 0.1 g watermelon 5.0 pp grape 0.5 y apple pear 0.4 ... ... 

I would like to remove all characters before the first space in the name column. Can someone do me a favor? Thanks!

Answer 1

Try the following:

 sub(".*? (.+)", "\\1", D$name) 

Answer 2

If D is your data frame, try

 sub(".+? ", "", D$name) 

Answer 3

Say your data frame is called 'df'

 library(reshape2) df$name = colsplit(df$name," ", names = c("chuck","name"))[,2]