Support Article

CSV file generated by BIX is creating unnecessary new row

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.
 

 

Published November 7, 2016 - Updated November 15, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.