FANTOIR parser

fantoir2csv.sh

#FANTOIR format to tabular, comma separated format (csv)
# Only parses "Voie".
# Let me know if you need "Commune" and "Direction"

# THE FANTOIR FILE
FILENAME=FANTOIR0721
HEADERS="Code département,Code direction,Code commune,Identifiant de la voie dans la commune,Clé RIVOLI,Code nature de voie,Libellé voie,FILLER,Type de la commune,FILLER,Caractère RUR,FILLER,Caractère de voie,Caractère de population,FILLER,Population à part,Population fictive,Caractère d’annulation,Date d’annulation,Date de création de l’article,FILLER,Code identifiant MAJIC de la voie,Type de voie,Caractère du lieu-dit,FILLER,Dernier mot"

head -n 10 $FILENAME | awk 'length($0) > 112' | sed -E 's/(.)/,\1/113' | sed -E 's/(.)/,\1/111' | sed -E 's/(.)/,\1/110' | sed -E 's/(.)/,\1/109' | sed -E 's/(.)/,\1/104' | sed -E 's/(.)/,\1/89' | sed -E 's/(.)/,\1/82' | sed -E 's/(.)/,\1/75' | sed -E 's/(.)/,\1/74' | sed -E 's/(.)/,\1/67' | sed -E 's/(.)/,\1/60' | sed -E 's/(.)/,\1/51' | sed -E 's/(.)/,\1/50' | sed -E 's/(.)/,\1/49' | sed -E 's/(.)/,\1/47' | sed -E 's/(.)/,\1/46' | sed -E 's/(.)/,\1/44' | sed -E 's/(.)/,\1/43' | sed -E 's/(.)/,\1/42' | sed -E 's/(.)/,\1/16' | sed -E 's/(.)/,\1/12' | sed -E 's/(.)/,\1/11' | sed -E 's/(.)/,\1/7' | sed -E 's/(.)/,\1/4' | sed -E 's/(.)/,\1/3' | (echo $HEADERS; cat -)