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.