many thanks; Nearly done; still my result looks like bs id birth_date date parity time quantity wt bcs quantity 1 IE121067041077 2011-04-07 2011-04-11 4 2 5.3 . . 5.3 2 IE121067041077 2011-04-07 2011-04-12 4 2 5.3 . . 17.2 3 IE121067041077 2011-04-07 2011-04-12 4 1 11.9 . . 17.2 4 IE121067041077 2011-04-07 2011-04-13 4 2 6.1 . . 18.0 5 IE121067041077 2011-04-07 2011-04-13 4 1 11.9 . . 18.0 6 IE151306820735 2010-01-31 2010-11-26 5 2 1.8 434 . 10.5 7 IE151306820735 2010-01-31 2010-11-26 5 1 8.7 434 . 10.5 8 IE151306820735 2010-01-31 2010-11-27 5 2 2.0 . . 7.3 9 IE151306820735 2010-01-31 2010-11-27 5 1 5.3 . . 7.3 10 IE151306820735 2010-01-31 2010-11-28 5 1 4.5 . . 4.5 11 IE151306820735 2010-01-31 2010-11-29 5 2 2.5 . . 7.5 12 IE151306820735 2010-01-31 2010-11-29 5 1 5.0 . . 7.5 but I just want to remove entry 2, 4, 6 because they are redundant and sot I only need one record per day and I dont need wt and quantity in new output file anymore. desired output 1 IE121067041077 2011-04-07 2011-04-11 4 2 5.3 . . 5.3 2 IE121067041077 2011-04-07 2011-04-12 4 2 5.3 . . 17.2 3 IE121067041077 2011-04-07 2011-04-12 4 1 11.9 . . 17.2 4 IE121067041077 2011-04-07 2011-04-13 4 2 6.1 . . 18.0 5 IE121067041077 2011-04-07 2011-04-13 4 1 11.9 . . 18.0 6 IE151306820735 2010-01-31 2010-11-26 5 2 1.8 434 . 10.5 7 IE151306820735 2010-01-31 2010-11-26 5 1 8.7 434 . 10.5 Thanx
... View more