Hi Fred, I'm no regex ninja (and I imagine one will be along shortly to solve your problem) but in your case does it simply suffice to drop the first 5 characters? That might be an easier sub() to write.
Best, Michael On Tue, Jul 24, 2012 at 12:36 PM, Fred G <bayespoker...@gmail.com> wrote: > 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]] > > ______________________________________________ > 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. ______________________________________________ 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.