Unpopular opinion: Semi-colon should be the default delimiter instead of comma or tab
This literally solves all the csv and tsv parsing problems.
- Tabs are hard to distinguish from spaces.
- Commas can easily mix with each other.
This literally solves all the csv and tsv parsing problems.
Personally my preferred one is the quick proof of concept that I threw together to teach a student that character delimitation is an arbitrary thing: the emoji-separated variable.
Of course they immediately proceeded to make 🍆 the delimiter and 💦 the quote, which I should've expected.
Ive dealt with pipe separated data, colon separated data, and tilde separated data
Honestly commas are the most disruptive delimiter to choose