BEGIN{OFS=";"} { gsub("Total Prec","Tot.Prec"); gsub("Precincts Rep","Precincts.Rep"); gsub(",",""); gsub("\\.",""); if ($1 == "County") { nCol = NF; } for (i=1;i<=(NF-nCol);i++) { printf("%s ",$i) } for (i=(NF-nCol)+1;i<=NF;i++) { printf("%s;",$i); } printf("\n") }