[R] Best way to replace :SS with :00

[Jason Rupert]

This is awesome!

Total continue to be amazed.

Thanks again!

--- On Thu, 7/16/09, Gabor Grothendieck <ggrothendieck at gmail.com> wrote:

> From: Gabor Grothendieck <ggrothendieck at gmail.com>
> Subject: Re: [R] Best way to replace :SS with :00
> To: "Jason Rupert" <jasonkrupert at yahoo.com>
> Cc: R-help at r-project.org
> Date: Thursday, July 16, 2009, 3:45 PM
> Try the following which replaces :
> followed by any two
> characters followed by space with the required string:
> 
> > x <- c("HH:MM:SS AM", "HH:MM:SS PM")
> > sub(":.. ", ":00 ", x)
> [1] "HH:MM:00 AM" "HH:MM:00 PM"
> 
> 
> On Thu, Jul 16, 2009 at 4:20 PM, Jason Rupert<jasonkrupert at yahoo.com>
> wrote:
> >
> > Dang it.  I forgot to mention the actual format of
> the time is the following:
> > "HH:MM:SS AM" or "HH:MM:SS PM"
> > And I would still hope for them to end up with the
> following format:
> > "HH:MM:00 AM" or "HH:MM:00 PM"
> >
> > How would you propose handling that condition?
> >
> > I tried to use strsplit with items to split on, but no
> luck.
> >
> > Thank you again for all your help.
> >
> >
> >
> >
> > --- On Thu, 7/16/09, Steve Lianoglou <mailinglist.honeypot at gmail.com>
> wrote:
> >
> >> From: Steve Lianoglou <mailinglist.honeypot at gmail.com>
> >> Subject: Re: [R] Best way to replace :SS with :00
> >> To: "Jason Rupert" <jasonkrupert at yahoo.com>
> >> Cc: R-help at r-project.org
> >> Date: Thursday, July 16, 2009, 2:58 PM
> >> Hi,
> >>
> >> > Not sure if there is an R way to do this or a
> regular
> >> express way, but here is what I am trying to do.
> >> >
> >> > I've got lots of data where the format is
> HH:MM:SS,
> >> but I need to format it like HH:MM:00, i.e. round
> the second
> >> down to zero.
> >> >
> >> > What is the best way to do this?
> >>
> >>
> >> Probably not the best way, but here's one way to
> do it,
> >> step by step:
> >>
> >> R> a <- rep("HH:MM:SS", 5)
> >> R> a
> >> [1] "HH:MM:SS" "HH:MM:SS" "HH:MM:SS" "HH:MM:SS"
> "HH:MM:SS"
> >>
> >> R> b <- strsplit(a, ":")
> >> R> b
> >> [[1]]
> >> [1] "HH" "MM" "SS"
> >>
> >> [[2]]
> >> [1] "HH" "MM" "SS"
> >>
> >> [[3]]
> >> [1] "HH" "MM" "SS"
> >>
> >> [[4]]
> >> [1] "HH" "MM" "SS"
> >>
> >> [[5]]
> >> [1] "HH" "MM" "SS"
> >>
> >> R> b2 <- lapply(b, function(pieces)
> >> c(pieces[1:2],"00"))
> >> R> b2
> >> [[1]]
> >> [1] "HH" "MM" "00"
> >>
> >> [[2]]
> >> [1] "HH" "MM" "00"
> >>
> >> [[3]]
> >> [1] "HH" "MM" "00"
> >>
> >> [[4]]
> >> [1] "HH" "MM" "00"
> >>
> >> [[5]]
> >> [1] "HH" "MM" "00"
> >>
> >> R> a2 <- sapply(b2, paste, collapse=':')
> >> R> a2
> >> [1] "HH:MM:00" "HH:MM:00" "HH:MM:00" "HH:MM:00"
> "HH:MM:00"
> >>
> >> HTH,
> >> -steve
> >>
> >> --
> >> Steve Lianoglou
> >> Graduate Student: Physiology, Biophysics and
> Systems
> >> Biology
> >> Weill Medical College of Cornell University
> >>
> >> Contact Info: http://cbio.mskcc.org/~lianos/contact
> >>
> >>
> >>
> >>
> >
> > ______________________________________________
> > 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.
> >
>