Problem to solve

Where I am licensed for the Extract Process function, when I export process data to CSV no comma is inserted for key fields where the value is blank. This means when I use text to columns etc. there is misalignment on any rows where optional data is absent.

Solution

Ensure that where a key field is present but has no data the output to CSV ensures a blank value/comma is inserted.