Hi, You could use: dat1<-data.frame(col1=c("Mercedes_02352","Audi_03555")) dat1[,1]<-as.numeric(gsub(".*_\\d{1}(.*)\\d{1}$","\\1",dat1[,1])) #if the number of digits are the same dat1 # col1 #1 235 #2 355 A.K.
----- Original Message ----- From: Mat <matthias.we...@fnt.de> To: r-help@r-project.org Cc: Sent: Wednesday, January 30, 2013 4:05 AM Subject: [R] substring from behind Hello together, i have a question for "substring". I know i can filter a number like this one: bill$No<-substring(bill$Customer,2,4) in this case i get the 2nd, 3rd and 4th number of my Customer ID. But how can i do this, if i want the 2nd, 3rd and 4th number of a column. Like this one. I have: Mercedes_02352 Audi_03555 and now i want to filter this data.frame to 235 355 can you help me? Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/substring-from-behind-tp4657029.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.