[R] substring from behind

arun smartpink111 at yahoo.com
Wed Jan 30 12:16:55 CET 2013


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.weber at fnt.de>
To: r-help at 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 at 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.




More information about the R-help mailing list