How to maintain columns in CSV file when the value is empty

[haskins.aaron]

Hi,

I am trying to write a report where sometimes the column values will be empty. However I still want the csv file to maintain the column even if there is no value.

Example

ID, FirstName, MiddleName, LastName

1,Tom,John,Smith

2,Fred,,Jones

In the second row, note there is nothing in the MiddleName.

Is this possible?

Thanks,

Aaron

[hozawa]

Yes. Both when importing csv and exporting to csv.