"""Find \asid[N] occurrences across all CSVs."""
import sys
import csv
import re
sys.stdout.reconfigure(encoding="utf-8")
from pathlib import Path

D = Path(r"c:\wamp64\www\csi-world\csv_data\csi-forever")
pat = re.compile(r"\\asid\[(\d+)\]", re.IGNORECASE)

for fname in ["Weapons.csv", "Armors.csv", "Items.csv", "States.csv", "Skills.csv"]:
    with (D / fname).open(encoding="utf-8-sig") as f:
        rows = list(csv.DictReader(f, delimiter=";"))
    hits = []
    for r in rows:
        text = (r.get("description", "") or "") + " " + (r.get("note", "") or "")
        for m in pat.finditer(text):
            hits.append((r["id"], r["name"], m.group(1)))
    print(f"{fname}: {len(hits)} occurrences")
    for h in hits[:8]:
        print(f"  id={h[0]:>4} {h[1]:30} -> skill #{h[2]}")
    if len(hits) > 8:
        print(f"  ... +{len(hits)-8} autres")