[0003: ~/.zipcodes]$ head .allCountries.txt
AD  AD100 Canillo             42.5833 1.6667  6
AD  AD200 Encamp              42.5333 1.6333  6
AD  AD300 Ordino              42.6  1.55  6
AD  AD400 La Massana              42.5667 1.4833  6
AD  AD500 Andorra la Vella              42.5  1.5 6
AD  AD600 Sant Julià de Lòria             42.4667 1.5 6
AD  AD700 Escaldes-Engordany              42.5  1.5667  6
AR  3636  POZO CERCADO (EL CHORRO (F), DPTO. RIVADAVIA (S)) Salta A         -23.4933  -61.9267  3
AR  4123  LAS SALADAS Salta A         -25.7833  -64.5 4
AR  4126  CEIBAL  Salta A         -26.1 -65.0167  4


======


[0003: ~/.zipcodes]$ cat .awkit.sh
#!/bin/bash

wDir="/home/.zipcodes"
inFile=".allCountries.txt"
outFile=".allCountries-formatted.txt"

cd "$wDir"
rm -f "$outFile"
awk '{printf "%s %-6s%-81s%-12s%-12s%s\n",$1,$2,gensub(/[0-9.-]* +[0-9.-]* +[0-9]$/,"","g",substr($0,10)),$(NF-2),$(NF-1),$NF}' "$inFile" | head > "$outFile"
cat "$outFile"


=======


[0003: ~/.zipcodes]$ bash .awkit
AD AD100 Canillo              42.5833 1.6667  6                                                   42.5833     1.6667      6
AD AD200 Encamp             42.5333 1.6333  6                                                    42.5333     1.6333      6
AD AD300 Ordino             42.6  1.55  6                                                         42.6        1.55        6
AD AD400 La Massana             42.5667 1.4833  6                                                42.5667     1.4833      6
AD AD500 Andorra la Vella             42.5  1.5 6                                                42.5        1.5         6
AD AD600 Sant Julià de Lòria              42.4667 1.5 6                                          42.4667     1.5         6
AD AD700 Escaldes-Engordany             42.5  1.5667  6                                           42.5        1.5667      6
AR 3636  OZO CERCADO (EL CHORRO (F), DPTO. RIVADAVIA (S)) Salta A         -23.4933  -61.9267  3 -23.4933    -61.9267    3
AR 4123  AS SALADAS Salta A         -25.7833  -64.5 4                                          -25.7833    -64.5       4
AR 4126  EIBAL  Salta A         -26.1 -65.0167  4                                               -26.1       -65.0167    4