[R] Please assist -- Unable to remove '-' character from char vector--

Sunny Singha sunnysingha.analytics at gmail.com
Mon Apr 25 08:35:23 CEST 2016


Hi,
I have a char vector with year values. Some cells have single year
value '2001-' and some have range like 1996-2007.
I need to remove hyphen character '-' from all the values within the
character vector named as 'end'. After removing the hyphen I need to
get the last
number from the cells where there are year range values i.e if the
cell has range 1996-2007, the code should return me 2007.

How could I get this done?

 Below are the values within this char vector:

> end
 [1] "2001-"            "1992-"            "2013-"            "2013-"
          "2013-"            "2013-"
 [7] "2003-"            "2010-"            "2009-"            "1986-"
          "2012-"            "2003-"
[13] "2005-"            "2013-"            "2003-"            "2013-"
          "1993–2007, 2010-" "2012-"
[19] "1984–1992, 1996-" "2015-"            "2009-"            "2000-"
          "2005-"            "1997-"
[25] "2012-"            "1997-"            "2002-"            "2006-"
          "1992-"            "2007-"
[31] "1997-"            "1982-"            "2015-"            "2015-"
          "2010-"            "1996–2007, 2011-"
[37] "2004-"            "1999-"            "2007-"            "1996-"
          "2013-"            "2012-"
[43] "2012-"            "2010-"            "2011-"            "1994-"
          "2014-"

I tried below command--> gsub('[-|,]', '', end)
This did remove all the hyphen character but not from cells having
range year values.Below is the result after executing above command:
As you see hypphen character is removed from single values but not
from ranges. Please guide.

> gsub('[-|,]', '', end)
 [1] "2001"           "1992"           "2013"           "2013"
  "2013"           "2013"           "2003"
 [8] "2010"           "2009"           "1986"           "2012"
  "2003"           "2005"           "2013"
[15] "2003"           "2013"           "1993–2007 2010" "2012"
  "1984–1992 1996" "2015"           "2009"
[22] "2000"           "2005"           "1997"           "2012"
  "1997"           "2002"           "2006"
[29] "1992"           "2007"           "1997"           "1982"
  "2015"           "2015"           "2010"
[36] "1996–2007 2011" "2004"           "1999"           "2007"
  "1996"           "2013"           "2012"
[43] "2012"           "2010"           "2011"           "1994"
  "2014"

Regards,
Sunny Singha



More information about the R-help mailing list