Shell Programming and Scripting

1000,Y,$2 ,10000,Students Plan
1001,M,$2 ,10001,Professional Plan
1002,M,$3 ,10002,Talk 199
1003,Y,$5 ,10003,Simple 30
1004,M,$3 ,10004,Flat 300

insert into elements values (1000, 'Y',10000);
insert into descriptions values (10000,'Students Plan');  

insert into elements values (1001, 'M',10001);
insert into descriptions values (10001,'Professional Plan');
.......

insert into elements values (1000, 'Y',10000);
insert into elements values (1001, 'M',10001);
.....
insert into descriptions values (10000,'Students Plan');  
insert into descriptions values (10001,'Professional Plan');
......

while IFS="," read c1 c2 c3 c4 c5
do
 echo "insert into table1 values ($c1,$c2,$c3,$c4,'$c5');"
done < csv_file | sort

 
awk -F"," -v v1="Cat" -v v2="Rat" -v v3="Cow" '{ a[$1]++ }
   END {
   if ( a[v1] >= 1 && a[v2] >= 1 && a[v3] >= 1 ) print "all";
   if ( a[v1] >= 1 && a[v2] >= 1 && a[v3] < 1 ) print "1 and 2";
   if ( a[v1] < 1  && a[v2] >= 1 && a[v3] >= 1 ) print "2 and 3";
   }' rem