I have a csv file with duplicates of info, sort of like this 6/8/2006,8:24:25,VENUS,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,503 Mb 6/7/2006,8:33:48,VENUS,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,503 Mb 6/6/2006,8:33:11,JUPITER,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,503 Mb 6/5/2006,8:43:45,JUPITER,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,503 Mb 6/5/2006,8:38:15,VENUS,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,255 Mb 6/2/2006,8:05:34,JUPITER,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,503 Mb 6/1/2006,8:36:05,JUPITER,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,503 Mb 5/31/2006,9:14:42,JUPITER,LAN,0AADAMS,Desktop,10.66.6.123,x86 Family 15 Model 2 Stepping 7,2400 MHz,255 Mb 6/5/2006,10:40:25,JUPITER,LAN,0ACCTGXTRA-2K,Desktop,10.66.6.99,x86 Family 6 Model 7 Stepping 3,548 MHz,256 Mb 6/5/2006,10:32:53,JUPITER,LAN,0ACCTGXTRA-2K,Desktop,10.66.6.99,x86 Family 6 Model 7 Stepping 3,548 MHz,256 Mb 5/22/2006,8:15:28,JUPITER,LAN,0AFROWISS,Portable,10.66.6.40,x86 Family 6 Model 13 Stepping 8,2127 MHz,2047 Mb 5/16/2006,8:02:49,VENUS,LAN,0AFROWISS,Portable,10.66.6.40,x86 Family 6 Model 13 Stepping 8,2127 MHz,2047 Mb 5/15/2006,8:14:43,JUPITER,LAN,0AFROWISS,Portable,10.66.6.40,x86 Family 6 Model 13 Stepping 8,2128 MHz,2047 Mb 6/8/2006,9:14:49,VENUS,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 6/7/2006,9:06:00,VENUS,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 6/1/2006,9:12:50,VENUS,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 5/31/2006,9:12:24,VENUS,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 5/26/2006,9:06:54,JUPITER,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 5/25/2006,9:11:58,VENUS,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 5/24/2006,9:14:33,VENUS,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 5/23/2006,9:37:04,VENUS,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 5/22/2006,9:05:00,JUPITER,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb 5/19/2006,9:10:58,JUPITER,LAN,0ALADEN,Desktop,10.66.6.57,x86 Family 6 Model 8 Stepping 3,863 MHz,383 Mb
Hope that doesn't wrap Anyway, I want to remove all the duplicates except one of the 5th field (hostname). I looked at uniq, but I couldn't find a way to just compare a certain field and ignore the rest. Thanks, Rich -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-newbie
