Shell Programming and Scripting

item , color ,desc
====  ======= ====
1,red ,abc
1,red , a b c
2,blue,x
3,black,y
4,brown,xv
4,brown,x v
4,brown,  x  v

 
1,red ,abc
2,blue,x
3,black,y
4,brown,xv

awk -F "," 'a[$1,$2]=="" {print $0 ;a[$1,$2]=$3}' urfile

 sed -n -e '/^[0-9]/s/ *//gp' file | sed 's/red/red /' | sort -u

 cat abc.txt
1,red ,abc
1,red , a b c
2,blue,x
3,black,y
4,brown,xv
4,brown,x v
4,brown,  x  v

cat abc.txt  | sort | uniq -w 1

 
open (FH,"<file") or die "Can't open";
my $val=1;
my $value;
 while($value=<FH>)
 {
   if($value=~/^$val/)
   {
       $val=$val+1;
       print "$value";
   }
 }

awk -F"," ' !a[$1$2]++ ' file

$ 
$ cat f9
1,red ,abc
1,red , a b c
2,blue,x
3,black,y
4,brown,xv
4,brown,x v
4,brown,  x  v
$ 
$ perl -lne '/([^,]+,[^,]+)/; print if $1 ne $p; $p = $1' f9
1,red ,abc
2,blue,x
3,black,y
4,brown,xv
$ 
$