I have managed to successfully export my table into CSV file. Unfortunately, there is one thing I cannot solve.
When one exports column defined as a character one and there is a number in it then it always puts double quotes around the number.
Any idea how to suppress these double quotes? I don’t want to have the double quotes in the final CSV file.
To give you even more context. The file is not used within the Excel. It is exported to CSV and then used by another ETL tool to be loaded into the final database. It may look messy but it is due to accesses and the fact that our DWH is in a different country.