Run SQL and export with pipe delimiter

Hi @GabrieleC102784 ,

If you are working with the AA Database: Read action: the existing option within it to export the query result to CSV has only the option to change the encoding type. Other than that, I don’t think we can do much customization on it.

If you were using the Datatable action, there is an option to change the Delimiter while saving the file where you can mention the Pipe symbol under Other category.

Since you are dealing with huge data, please stick with Database action only. As a workaround, you need to some changes to your system to make this work.

1. Open the Control Panel on your computer. In the Control Panel window, please select Category from the View by drop-down list, then click the Clock, Language, and Region option.

2. In the Clock, Language, and Region window, click Region (or Region and Language) on the right side.

3. In the Region (or Region and Language) dialog box, click the Additional Settings… button.

4.Then the Customize Format dialog box is opening. Please remove the comma in the List separator box under the Numbers tab, then press the Shift + \ keys together to enter the | delimiter into the List separator box, and finally click the OK button.

If you don't want to do changes system wide, you may achieve the same through some inline scripts like Python or JS.