It gets very nasty at this point especially because I’ve used popular languages who’s CSV parsing libraries were unable to handle some weird quotes properly.
What languages? No option to configure any character as quote character or delimiter?
Ruby. Python. Several JavaScript NPM packages. Part of the problem here is the standards around CSVs aren’t consistent, nor are they well respected.
Things get even weirder when you throw non-Latin characters in the mix. May such parsers predate widespread use of UTF-8.