Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
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 B2C Service 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.
