Tools disagree on what whitespace means. DuckDB's trim(x) removes spaces only; pandas .str.strip() removes all Unicode whitespace. Name the characters you remove, and never change the inside of the value.
- Lesson: Trim the right characters, and only those
- Practise: Clean an order-line export
Related: Unicode normalization (NFC), Leading zeros