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

Delimiter to be changed for CSV generated by BIX

SA-22555

Summary



Due to an issue with downstream processing, the delimiter used for CSV generated by BIX must be changed with Business Intelligence Exchange (BIX) 7.2.  
​User requires the delimiter to be something other than a comma.


Error Messages



Not applicable.


Steps to Reproduce



Not applicable.


Root Cause



It is expected that BIX will use a comma as the default delimiter.

Resolution



To change default delimiter, use the -l parameter and specify what character to use instead of a comma.

Note, that the following characters are not available for use as delimiters, as they signify other things to BIX:

Double-quote (“)
Asterisk (*)
Hyphen (-)

BIX also does not support multi-line delimiters. If the delimiter length is greater than 1, then BIX reports an error.
Suggest Edit

Published May 4, 2016 - Updated December 2, 2021

Did you find this content helpful? Yes No

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.

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