The Kopis Blog
Software Development Insights & Tech Discoveries
Efficiency and profitability insights, software development trends, process suggestions, interesting ideas—from people who think about this stuff all the time.
Efficiency and profitability insights, software development trends, process suggestions, interesting ideas—from people who think about this stuff all the time.
03/13/20
One particularly tedious task that folks developing ETL operations in T-SQL face at least once in their careers is the task of scrubbing textual data of unwanted – and sometimes non-displayable – characters. Somehow these special characters that cannot be displayed end up in the data; few know how or why and obviously they cannot be seen so we find out about them when some process chokes in the dead of night on a weekend because the antiquated “BEL” character somehow showed up in the data.