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

BIX extract into a CSV file issue

SA-20393

Summary



As part of user's application BIX is being used to update and extract data into a CSV file using delimiter as comma ','.
Output file is being processed using BI tools. While the csv file is being created data is being created consists of comma followed by a space enclosed in double quotes (, "field1", "field2"). The space between the comma and doubles quotes is causing issue.

Error Messages



Not applicable.

Steps to Reproduce



Create an extract using 'CSV' as ouput type.

Root Cause



A defect in Pegasystems’ code or rules: Additional space is being introduced, due to wich data is interpreted inconsistely while using BI tools.

Resolution



User is adviced to use pxExtractDataWithArgs using '-l' as an argument (pyargs) seperated by a single character delimiter, which gives a CSV file without the additinal space character.
As there was no response from the user or confirmation, we are closing this.
Suggest Edit

Published March 4, 2016 - Updated October 8, 2020

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