Материалы · 6 мин чтения
Numeric locales in CSV: commas, decimals, and currency symbols
EU vs US number formats: thousand separators, decimal commas, and safe normalization before CAST.
Опубликовано 21 марта 2025 г. · Table
A file from a German subsidiary may use 1.234,56 € while US systems expect 1234.56. Blind casting fails or silently drops precision.
Mitigation
- Tag source locale in the filename or manifest.
- Strip currency symbols in ETL, not in the legal source file.
- Keep raw strings until a single normalization step owns the rules.