Export Datagrid to flat file that doesn't use a comma delimiter
I am trying to export data from the Capital Projects reporting cube to a text file, using a DataGrid. The groovy operation to do so is operation.exportDataToFile(dataGrid, sourceFileName). However, this only allows data to be exported with a comma separated delimiter. I want to export data with a different delimiter (example pipe delimiter) because the data itself (certain project properties) have commas. I have been unable to do so. How can this be done?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):