Regular Expression

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
project.org] On Behalf Of Fred G
Sent: Tuesday, July 24, 2012 12:36 PM
To: r-help at r-project.org
Subject: [R] Regular Expression

Hi--

I have three columns in an input file:
MONTH   QUARTER  YEAR
2012-07   2012-3        2012
2001-07   2001-3        2001
2002-01   2002-1        2002

I want to make output like so:
MONTH   QUARTER  YEAR
07           3                2012
07           3                2001
01           1                2002

I was having some trouble getting the regular expression to work.  I
think
it should be something like the following:
tmp <- uncurated$MONTH
*tmp <- gsub("[^-\\d\\d]","",tmp,perl=TRUE)*
*tmp[tmp=="-"] <- ""*
*curated$MONTH <- tmp*
*
*
tmp <- uncurated$QUARTER
*tmp <- gsub("[^-\\d]","",tmp,perl=TRUE)*
*tmp[tmp=="-"] <- ""*
*curated$QUARTER <- tmp*
*
*
*but it's not quite working. I want to be able to isolate any digits
that
occur after the hyphen and to delete everything before and including
the
hyphen. Would greatly appreciate any clarification anyone can provide.*

	[[alternative HTML version deleted]]