CSV file generated by BIX is creating unnecessary new row
SummaryWhenever 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 MessagesNot applicable
Steps to Reproduce1. User enters the Text or Note with new line.
2. Generate the CSV file.
Text editor or an application which is used to open the extracted csv file is responsible to parse the file in required format.
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:
6. Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes. For example:
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