Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

CSV file generated by BIX is creating unnecessary new row



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.


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:
"aaa","b CRLF
bb","ccc" CRLF

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


Published November 15, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us