I have a character string that represents a time duration. It has an hours minutes seconds structure(ish) but with letters denoting units (H,M or S) no leading zeros and no placeholder at all where one or other of the units are not required.
It looks like this: t<-c("10H20M33S","1H1M","1M","21M9S","2H55S" )) df<-data.frame(t) df #ideally should look like: t2<-c("10:20:33","01:00:01","00:01:00","00:21:09","02:00:55") df2<-data.frame(t2) df2 I need to get it into hours minutes and seconds either in time format or as a string with leading zeros and all three time units represented in each one, as in df2. The data, part of a very large dataset, are for onward use and processing in a GIS application. I’ve messed about with string handling statements in SQL to no avail, but wondered if R would be a better bet? I’ve had a look at some of the commands in stringr, but am unsure how to operationalise a solution using this package. Any advice is welcome. -- View this message in context: http://r.789695.n4.nabble.com/A-problem-with-string-handling-to-make-a-time-duration-tp4706795.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.