awk -F"," '{ if(_[$1]==0){ _[$1]=1 print $0 } }' a > t1 join -t"," -11 -25 t1 b | nawk -F"," '$3=sprintf("%011.2f",$3);gsub(/\./,"",$3)'