On Wed, 03 Jul 2013, Ye Lin writes:
> Hey All,
>
> I want to standardize my timestamp which is formatted as hh:mm:ss
>
> My data looks like this:
>
> Date Time
> 01/01/2013 00:09:01
> 01/02/2013 00:10:14
> 01/03/2013 00:11:27
> 01/04/2013 00:12:40
> 01/05/2013 00:13:53
> 01/06/2013 00:1
Hi,
May be this helps:
dat1# dataset
dat1[,2]<-gsub("\\d+$","00",dat1[,2])
dat1
# Date Time
#1 01/01/2013 00:09:00
#2 01/02/2013 00:10:00
#3 01/03/2013 00:11:00
#4 01/04/2013 00:12:00
#5 01/05/2013 00:13:00
#6 01/06/2013 00:15:00
#7 01/07/2013 00:16:00
#8 01/08/2013 00:17:00
#
Hey All,
I want to standardize my timestamp which is formatted as hh:mm:ss
My data looks like this:
Date Time
01/01/2013 00:09:01
01/02/2013 00:10:14
01/03/2013 00:11:27
01/04/2013 00:12:40
01/05/2013 00:13:53
01/06/2013 00:15:06
01/07/2013 00:16:19
01/08/2013 00:17:32
01/09/2013 00:18
3 matches
Mail list logo