awk -F! ' {
printf "%-15s",$2
if($1=="")
printf "%-6s",substr($2,length($2)-5)
else printf "%-6.6s",$1
printf "%-40.40s",$4
printf "%-25.25s",$3
split($0,a," ")
printf "%-40s",a[1]
printf "%-40s",a[1]"/"a[2]
printf "%-5s","IVA"
printf "%-5s",""
printf "%-10s","C/U"
printf "%-13s",""
printf "%-13s",""
printf "%-3s","1"
printf "%-7s",$6
printf "%-3s",""
printf "%-7s",""
printf "%-3s",""
printf "%-7s",""
printf "%-10s","SIN/SERIE"
printf "%-5s",""
printf "%-10s",""
printf "%-5s",""
printf "%-5s",""
printf "%-10s","VIGENTE"
} ' FINAL1
