[R] Removing colon from numerical data
    LCOG1 
    jroll at lcog.org
       
    Thu Mar  4 18:12:09 CET 2010
    
    
  
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.
    
    
More information about the R-help
mailing list