import csv

INPUT_FILE = "/var/www/html/modification_carto/modfiles_all.csv"
OUTPUT_FILE = "/var/www/html/modification_carto/modfiles_all_clean.csv"

with open(INPUT_FILE, "r", encoding="utf-8", errors="ignore") as infile, \
     open(OUTPUT_FILE, "w", newline="", encoding="utf-8") as outfile:
    
    reader = csv.reader(infile, delimiter=";")
    writer = csv.writer(outfile, delimiter=";")
    
    for row in reader:
        # on enlève espaces inutiles
        row = [c.strip() for c in row if c.strip() != ""]

        # si plus de 6 colonnes -> on coupe
        if len(row) > 6:
            row = row[:6]
        # si moins de 6 colonnes -> on complète
        elif len(row) < 6:
            row += [""] * (6 - len(row))
        
        writer.writerow(row)

print(f"✅ Nettoyage terminé → {OUTPUT_FILE}")