BEGIN{FS=OFS="\t"; scoreI=9;#9:ModeScore; 10:AvgConversionPct; 11:MaxConversionPct }{ n=split($4,a,",");m=-1; for(i=1;i<=n;i++){ split(a[i],b,"_");x=b[scoreI]; if (x>m){m=x;mi=i; ma=b[11];} # print "MS "i" "x" "mi } print $1,$2,$3,a[mi],$5,$6,$7; }