blank columns in CSV output file

Question

Hi all, I am trying to create a CSV file in which several columns should remain empty. I created the columns with the Formula tool and fill the cells first with Null, after which I used the Cleanse tool to clear all those cells. In Designer the columns look empty, but when the CSV file is saved to the output folder there are "" in all those cells. Any ideas how to get rid of those "" ?

Thanks in advance

Roger

davidskaife · Accepted Answer

Hi @Greenlama254

In your Output tool there is a setting for Quote Output Fields, which is set to Auto by default. Simply change this to Never