Try this: D <- as.numeric(gsub("[[:punct:]]", "", D))
On Thu, Mar 4, 2010 at 2:12 PM, LCOG1 <jr...@lcog.org> wrote: > > Basic question, looked through the forum and documentation but didnt see a > solution. > > So consider > > O<-c(1:20) > D<-c("1:","2:","3:","4:","5:","6:","7:","8:","9:","10:","11:","12:","13:","14:","15:","16:", > "17:","18:","19:","20:") > Time<-c(51:70) > > AveTT<-data.frame(O,D,Time) > > > I would like to remove the colon from the "D" column's data. This is how > the data is being given to me and its too big to put into excel to remove > the colons. I tried the below but neither returns what i want. > > AveTT$D<-as.numeric(AveTT$D) > > AveTT$D<-substr(AveTT$D,1,nchar(AveTT$D)-1) > > so i want > O D Time > 1 1 1: 51 > 2 2 2: 52 > 3 3 3: 53 > 4 4 4: 54 > 5 5 5: 55 > 6 6 6: 56 > 7 7 7: 57 > 8 8 8: 58 > 9 9 9: 59 > 10 10 10: 60 > > to become > > O D Time > 1 1 1 51 > 2 2 2 52 > 3 3 3 53 > 4 4 4 54 > 5 5 5 55 > 6 6 6 56 > 7 7 7 57 > 8 8 8 58 > 9 9 9 59 > 10 10 10 60 > > while maintaining the data's integrity. Thanks > > JR > > -- > View this message in context: > http://n4.nabble.com/Removing-colon-from-numerical-data-tp1578397p1578397.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. > -- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O ______________________________________________ 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.