Support Article

Comma separator values are breaking when extracting using BIX

SA-25591

Summary



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.

Resolution



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.