I have a file with these columns file, start and end
file start end
/hold/ABCD6-90-2008-02-06-
03.59.36-2
008-02-05.
csv 3/3/2008 10:54:49.000 PM 3/4/2008 10:30:21.000 AM
/hold/DEF6-90-2008-02-06-0
3.59.36-20
08-02-05.c
sv 3/3/2008 11:54:46.000 PM 3/3/2008 10:54:46.000 PM
Here the number attached to ABCD, DEF is the customer number. Each customer number has two files attached to it. I need to find the minimum start time between these files and maximum end time between the two files and also the associated customer number.
Therefore I need to write the following data to the file:
customer start end
6 10:54:46.000 11:54:46.000
Please advice how can i approach this problem in Perl.
Start Free Trial