3 ms·
Yeah but this has nothing to do with CSV. It's just about handling user input in general. try standard parsing, if fail try exotic features, if fails try so co
by sametmax 9y ago
Yeah but this has nothing to do with CSV. It's just about handling user input in general.
try standard parsing, if fail try exotic features, if fails try so common hacks around common mistake, if fails just reject it as invalid data.
We all do that all the time for everything. Form input, video upload, user click in a MMO, etc.
- ryanbrunner 9y agoOne challenge is that rejecting, or even detecting that something is wrong is often not a simple decision to make. Parsing a CSV in an invalid encoding will usually produce "valid" but nonsensical output. Determining that that has happened when your destination schema is somewhat freeform can be a challenge.