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.
