Earlier this week another user asked a related question and the answer is that it is unfortunately not possible now. We will however discuss it shortly. We will keep you updated.
Your option is to do a replace in a text editor.
Awesome! Thank you!
Is there a way to specify an ASCII character to use for CsvColumnDelimiter when using export?
Specifically ASCII 28 (octal 34), the File Separator character?
The "Exporting Query Results" documentation only provides the default value, it doesn't specify the valid value options for this parameter.