Search services

Search tools and open pages quickly

بینش‌ها · 6 دقیقه مطالعه

Numeric locales in CSV: commas, decimals, and currency symbols

EU vs US number formats: thousand separators, decimal commas, and safe normalization before CAST.

منتشرشده در ۱ فروردین ۱۴۰۴ · FreeLocalConverter

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.

← همه مقالات

مورد استفاده تیم‌های پیشرو

لوگوهای اسکرول‌شونده (هر پیوند سایت برند را در تب جدید باز می‌کند): GlobalVideo, Google, Apple, Meta, GitHub, Stripe, Shopify, Databricks, Snowflake, Notion, Vercel, Intel, NVIDIA, Netflix, Spotify, Airbnb, Yale, Harvard University, Massachusetts Institute of Technology, Stanford University, University of California, Berkeley, Princeton University, California Institute of Technology, Columbia University, University of Chicago, Cornell University, Duke University, Carnegie Mellon University, Georgia Institute of Technology, Johns Hopkins University, Northwestern University, University of Toronto, McGill University, University of Oxford, University of Cambridge, Imperial College London, University College London, ETH Zurich, EPFL, Technical University of Munich, Sorbonne University, KU Leuven, National University of Singapore, Nanyang Technological University, Tsinghua University, Peking University, The University of Tokyo, KAIST, Seoul National University, University of Melbourne, Australian National University, University of Sydney, The University of Hong Kong.

Google website (opens in a new tab)Apple website (opens in a new tab)Meta website (opens in a new tab)GitHub website (opens in a new tab)Stripe website (opens in a new tab)Shopify website (opens in a new tab)Databricks website (opens in a new tab)Snowflake website (opens in a new tab)Notion website (opens in a new tab)Vercel website (opens in a new tab)Intel website (opens in a new tab)NVIDIA website (opens in a new tab)Netflix website (opens in a new tab)Spotify website (opens in a new tab)Airbnb website (opens in a new tab)Yale website (opens in a new tab)