I've had a very colorful morning learning the innerparts of Linux's
sort command, and have come across yet another issue that I can't seem to find an answer for in the documentation.
I'm currently using
-t, to indicate that my fields are split by the comma character, but I'm finding that in some of my files, the comma is used (between double-quotes) within values:
Jonathan Sampson,,firstname.lastname@example.org,0987654321 "Foobar CEO,","CEO,",email@example.com,,
How can I use a comma to terminate my fields, but ignore the occurences of it within values?
Is this fairly simple, or do I need to re-export all of my data using a more-foreign field-terminator? (Unfortunately, I do not have any control over declaring a different terminator with this particular project).