with(df, substr(DESCRIPTION, start=1, stop=nchar(DESCRIPTION) - 10)) ?nchar
On 4/23/2010 11:57 AM, arnaud Gaboury wrote: > Dear group, > > > > Here is my df : > > > > df <- > > structure(list(DESCRIPTION = c("PRM HGH GD ALUMINIUM USD 09/07/10 ", > > "PRM HGH GD ALUMINIUM USD 09/07/10 ", "PRIMARY NICKEL USD 04/06/10 " > > ), CREATED.DATE = structure(c(18361, 18361, 18325), class = "Date"), > > QUANITY = c(-1L, 1L, 1L), CLOSING.PRICE = c("2,415.90", "2,415.90", > > "25,755.71")), .Names = c("DESCRIPTION", "CREATED.DATE", > > "QUANITY", "CLOSING.PRICE"), row.names = c(NA, 3L), class = "data.frame") > > >> df > > DESCRIPTION CREATED.DATE > QUANITY CLOSING.PRICE > > 1 PRM HGH GD ALUMINIUM USD 09/07/10 2020-04-09 -1 > 2,415.90 > > 2 PRM HGH GD ALUMINIUM USD 09/07/10 2020-04-09 1 > 2,415.90 > > 3 PRIMARY NICKEL USD 04/06/10 2020-03-04 1 > 25,755.71 > > > > > > > > In the DESCRIPTION column, I want to get rid of the date (09/07/10 .). I > know the function substr(x, start, stop), but in my case, I need to indicate > I want to start from the end of the vector, and I have no idea how to pass > this argument. > > TY for any help > > > > > > > > > > > > > > *************************** > > Arnaud Gaboury > > Mobile: +41 79 392 79 56 > > BBM: 255B488F > > *************************** > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. -- Chuck Cleland, Ph.D. NDRI, Inc. (www.ndri.org) 71 West 23rd Street, 8th floor New York, NY 10010 tel: (212) 845-4495 (Tu, Th) tel: (732) 512-0171 (M, W, F) fax: (917) 438-0894 ______________________________________________ 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.