Use regular expressions:
> df$newDesc <- sub("(\\d+/\\d+/\\d <file://d+///d+///d>+)", '',
df$DESCRIPTION)
> df
DESCRIPTION CREATED.DATE QUANITY
CLOSING.PRICE newDesc
1 PRM HGH GD ALUMINIUM USD 09/07/10 2020-04-09 -1 2,415.90 PRM
HGH GD ALUMINIUM USD
2 PRM HGH GD ALUMINIUM USD 09/07/10 2020-04-09 1 2,415.90 PRM
HGH GD ALUMINIUM USD
3 PRIMARY NICKEL USD 04/06/10 2020-03-04 1
25,755.71 PRIMARY NICKEL USD
On Fri, Apr 23, 2010 at 11:57 AM, arnaud Gaboury
<arnaud.gabo...@gmail.com>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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
[[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.
