Skip Navigation
Expand
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?

Environment:

Analytics, Site Configuration
Oracle Service Cloud all versions

Resolution:

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.

Example:

ID, First_Name, Last_Name, Address
1,"John","Smith","1042 Baker St.
London
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.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.