Changing the CSV Delimiter and Enclosure Characters on a Mac

TIL that you can’t change the CSV delimiter or enclosure characters on Excel for Mac or Apple Numbers. You have to use Open Office, and even there it is tricky. You need to go to File > Save As, select Text CSV, then make sure you check the “Edit Filter Settings” checkbox:

Then you get the field option AFTER you hit Save, only if the Edit Filter settings box is checked: