Support Article

Comma separator values are breaking when extracting using BIX



BIX extract to Comma Separated Value format places properties in the wrong column when properties have embedded commas.

Error Messages

Not applicable

Steps to Reproduce

  1.  Created a BIX extract with output as a Comma Separated Values (CSV)
  2. Include properties where values can contain the comma (,) character
  3. Run extract and view as CSV file

Root Cause

This is expected behavior.


Use one of the following solutions:
  1. Change the BIX output to XML.
  2.  If third-party interpretation cannot accept XML output, change the BIX extract to specify a delimiter other than a comma by using the command-line argument "-l" when running a command-line BIX extract.


Published July 14, 2016 - Updated July 23, 2016

Have a question? Get answers now.

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