02-16-2009
2,
0
Join Date: Feb 2009
Last Activity: 17 February 2009, 5:34 AM EST
Posts: 2
Thanks Given: 0
Thanked 0 Times in 0 Posts
Need help on file processing algorithm.
Hi,
I have a data file having 3 fields. AC No, Start date, end date.
101|07/19/2008|07/21/2008
102|07/20/2008|07/21/2008
101|07/18/2008|07/21/2008
105|07/16/2008|07/21/2008
103|07/21/2008|07/21/2008
104|07/19/2008|07/21/2008
102|07/14/2008|07/21/2008
i need a script that would give me list of AC No for each date between the minimum maximum date range.
My expected output would be
07/14/2008=>102
07/15/2008=>102
07/16/2008=>102, 105
07/17/2008=>102, 105
07/18/2008=>102, 105, 101
07/19/2008=>102, 105, 101, 104
07/20/2008=>102, 105, 101, 104
07/21/2008=>102, 105, 101, 104, 103
Any solution or pointers would be a great help.
Thanks in advance.