SA-13216

Summary

Escape characters are causing different issues in the CSV file generated using BIX Extract.
Some examples are given below:
- Any field having Enter, "\n" causes new row in the CSV file generated using BIX Extract.
- Any field having Comma "," causes new column.

Error Messages

Not Applicable

Steps to Reproduce

1. Enter "enter" command in any field having text area control.
2. Extract this field using BIX and generate CSV file.
 

Resolution

The CSV file generated by BIX conforms to the RFC 4180 standard.

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 
[/quote]

It is up to the application program that reads the CSV, to process it as per the standard, if required. 
For example: DB2 is able to correctly load the generated CSV into a table, whereas MS Excel will interpret the newline character even though the corresponding field is quoted.