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.
Things get even weirder when you throw non-Latin characters in the mix. May such parsers predate widespread use of UTF-8.