SA-30071

Summary

Whenever generating a csv file with some information from the Work Object and if any note or free text encounters a new line, a new row is created in the corresponding CSV file which is not expected.

Error Messages

Not applicable

Steps to Reproduce

1. User enters the Text or Note with new line.
2. Generate the CSV file.

Root Cause

Text editor or an application which is used to open the extracted csv file is responsible to parse the file in required format.

Resolution

Case Data entered in text area contains “\r\n” special characters.

The CSV file generated by Business Intelligence Exchange (BIX) conforms to the RFC 4180 standard, hence use a RFC-4180 parser for downstream applications.

An excerpt From RFC-4180:
​
[quote]
6. Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes. For example:
"aaa","b CRLF
bb","ccc" CRLF
zzz,yyy,xxx
[unquote]

It is up to the application program that reads the CSV, to process it as per the standard, if required.