Symptom
The CSV file generated when using the Export Based on Export Definition option directly at the target group or Create Export File at campaign has empty rows, breaking the file formatting.
Environment
SAP Marketing Cloud
Cause
This is a system limitation when the entries' value of the attribute used in the Export Definition have line breaks. When the CSV file is rendered these line breaks are not suppressed, which causes the empty lines between different entries/rows at the resulting file.
Resolution
This is the expected system behaviour.
An alternative is to submit your feature request through SAP Influence so that the feature could be evaluated by product management and possibly implemented in future releases. Please refer to KBA 2812948 - How To: Enhancement Request Process for SAP Marketing Cloud Using the Customer Influence Platform.
See Also
export file, export definition, create export file, blank format, enter, line break
Keywords
KBA , CEC-MKT-EXP , Export Definitions , Problem