Skip Navigation
Unexpected line breaks in the exported CSV file
Answer ID 10094   |   Last Review Date 03/18/2019

Why there is a line breaks in the exported CSV file?


Analytics, Site Configuration
Oracle B2C Service all versions


CSV or Comma-Separated Values file stores tabular data as a plain text. Where each field separated by commas and each record is placed on a new line; however, this is not always the case. CSV format also supports multi-line strings as long as string enclosed in double-quotes.


ID, First_Name, Last_Name, Address
1,"John","Smith","1042 Baker St.
United Kingdom"
2, "Mark","McGuire"," 201 Tempest St.
New York
United States"

This would be a valid CSV file and this is not unusual. Specifically, behavior can be observed during report exporting where custom or a standard text field such as "notes" or "address" is present and contain multi-line text.