Re: how to compare time between 2 fields ?

There is no name1 line. There is no date in dd-MM-YYYY format.

Show us your code and a reasonable part of your actual data, both wrapped in <code> tags. Don't put code or data into <pre> tags, and especially don't put your question into <pre> tags, use <p> tags for that.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Comment on Re: how to compare time between 2 fields ?

Replies are listed 'Best First'.
Re^2: how to compare time between 2 fields ? by sillybees (Initiate) on Jun 30, 2010 at 03:56 UTC
Thank you. I already posted the data inputfile. `name1##Thu Oct 18 14:33:23 2007 ## 2007-10-18 14:33:23.000000000-0400 name2##Thu Feb 5 01:13:19 2009 ##2009-02-05 01:13:19.000000000-0500 name3##Sat Jan 24 10:03:37 2009 ##2009-01-24 10:03:37.000000000-0500 name8##Thu Feb 5 01:13:19 2009 ##2007-03-05 01:13:19.000000000-050 +0 (... 1000s of similar entries)` [download] I never tried perlmonks before. Sorry for not using proper tag. In regards to your other question, data format in field2 is different than field3. If these two times are of epoch timeformat, I can compare the strings myself. Because they use different format in field 2 and 3, I don't know how to compare them myself. My perl code may not help here as it was collecting field2 and field3 from two different file for the names in field1. Thanks pad	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: how to compare time between 2 fields ?
by sillybees (Initiate) on Jun 30, 2010 at 03:56 UTC

Thank you. I already posted the data inputfile.

name1##Thu Oct 18 14:33:23 2007  ## 2007-10-18 14:33:23.000000000-0400
name2##Thu Feb  5 01:13:19 2009  ##2009-02-05 01:13:19.000000000-0500
name3##Sat Jan 24 10:03:37 2009  ##2009-01-24 10:03:37.000000000-0500
name8##Thu Feb  5 01:13:19 2009    ##2007-03-05 01:13:19.000000000-050
+0
(... 1000s of similar entries)
[download]

I never tried perlmonks before. Sorry for not using proper tag. In regards to your other question, data format in field2 is different than field3. If these two times are of epoch timeformat, I can compare the strings myself. Because they use different format in field 2 and 3, I don't know how to compare them myself. My perl code may not help here as it was collecting field2 and field3 from two different file for the names in field1.

Thanks pad

[reply]
[d/l]