Re: [R] Merging 2 files with different timestamp

2016-05-23 Thread Jeff Newmiller
You have by now seen some other responses on the list. Keeping the list included will insure you continue to get mulitple eyes looking at the problem and will benefit others trying to use the answers. Two comments: 1) Your first format includes a specification for seconds. If that is nonzero

Re: [R] Merging 2 files with different timestamp

2016-05-22 Thread David Winsemius
> On May 22, 2016, at 9:40 AM, Bhaskar Mitra wrote: > > Hello, I am trying to merge two text files by using the timestamp > header for both the files: > > The first file has the following format for the timestamp:"2012-01-01 > 23:30:00 UTC" > > Timestamp for the second file : 2012-01-01 2330.

Re: [R] Merging 2 files with different timestamp

2016-05-22 Thread jim holtman
Is this the format of a column within the two different files? If they are columns, here is a way of converting to a common format for merging: > # convert to POSIXct > date1 <- as.POSIXct("27-Dec-12 23H 30M 0S", format = "%d-%b-%y %HH %MM %SS") > date2 <- as.POSIXct('2012-12-27 2330', format =

Re: [R] Merging 2 files with different timestamp

2016-05-22 Thread Jeff Newmiller
What time zone are these data in? Does daylight savings adjustment apply? -- Sent from my phone. Please excuse my brevity. On May 22, 2016 9:48:08 AM PDT, Bhaskar Mitra wrote: >Hello, > >My apologies for the earlier posting. There was an error with regard to >my >query : > > >I am trying to mer

[R] Merging 2 files with different timestamp

2016-05-22 Thread Bhaskar Mitra
Hello, I am trying to merge two text files by using the timestamp header for both the files: The first file has the following format for the timestamp:"2012-01-01 23:30:00 UTC" Timestamp for the second file : 2012-01-01 2330. I am having problems by converting from one timestamp format to anothe

Re: [R] Merging 2 files with different timestamp

2016-05-22 Thread Bhaskar Mitra
Hello, My apologies for the earlier posting. There was an error with regard to my query : I am trying to merge two text files by using the timestamp header for both the files: The first file has the following format for the timestamp:"27-Dec-12 23H 30M 0S" Timestamp for the second file : 2012-