Re: [R] Simple regex problem

From: Ted Harding <Ted.Harding_at_manchester.ac.uk>
Date: Sat, 10 May 2008 18:14:36 +0100 (BST)


On 10-May-08 16:49:20, John Kane wrote:
> I am cleaning up some character data to convert to
> dates using chron. The regex that I am using work fine
> but there should be a better way to do this. Can
> anyone suggest a cleaner bit of code than the gsub,
> sub approach? Thanks
>

>#Test Run on dates.

> xx <- c("May 1, 2007",
> "May 2, 2007",
> "May 3, 2007",
> "May 4, 2007",
> "May 5, 2007",
> "May 6, 2007",
> "May 7, 2007",
> "May 8, 2007",
> "May 9, 2007",
> "May 10, 2007",
> "May 11, 2007",
> "May 12, 2007")
> yy <- gsub(" +", "/", xx) ; yy
> zz <- sub(",", "", yy) ; zz

You can do it in one stroke with

gsub(",*[ ]+", "/", xx)
 [1] "May/1/2007"  "May/2/2007"  "May/3/2007"  "May/4/2007"
 [5] "May/5/2007"  "May/6/2007"  "May/7/2007"  "May/8/2007" 
 [9] "May/9/2007"  "May/10/2007" "May/11/2007" "May/12/2007"

> library(chron)
> ttdates <- chron(zz, format = c(dates = "mon/d/y"))

Best wishes,
Ted



E-Mail: (Ted Harding) <Ted.Harding_at_manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861
Date: 10-May-08                                       Time: 18:14:33
------------------------------ XFMail ------------------------------

______________________________________________
R-help_at_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. Received on Sat 10 May 2008 - 17:34:26 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 10 May 2008 - 18:30:36 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive