3 ms·
Even when using libraries to read CSV data the need for sanitization isn't uncommon. Sure there's RFC4180, but variations are common. Mysterious records that ar
by aww_dang 6y ago
Even when using libraries to read CSV data the need for sanitization isn't uncommon. Sure there's RFC4180, but variations are common. Mysterious records that are out of sync are typical.
For my own sanity I like to verify that columns are of the right data type where possible.
That said, I still prefer CSV over heavier formats (XML,JSON) where the data conforms.