Is there any way to do this? I need to use a pipe "|" as my delimiter. On Windows you can change this during the export. On Mac I haven't found a way. As a side note, my files have commas in the data itself.
If you're willing to move away from Excel, you could try using OpenOffice or LibreOffice to create
.csv files. They're both free, they both have most of the functionality included in Excel, and they both allow tabulated data to be saved as a
.csv file using any character as a data separator or text delimiter (including the pipe, of course).
All well and good, but don't try to use low level text file manipulation utilities on the files that you create (ie *IX programs like awk). They won't be able to distinguish commas inside quotes from those without. Pipe delimiters are better as they clash less frequently with normal everyday usage (eg commas in addresses, or as separators in numbers).