7

Generate tabular data based on a column value from an existing data file

view full story
linux-howto

http://www.unix.com – Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I need to find the first occurring date and the last occurring date for a particular value in column 4 for each combination of column 2 and 3 For example the output from above data should be: 1,1,01/28/2012,01/29/2012,98955 1,1,01/30/2012,02/01/2012,98896 1,1,02/02/2012,99/99/9999,98899 1,2,0 (HowTos)