BIX extract into a CSV file issue
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.
Steps to Reproduce
Create an extract using 'CSV' as ouput type.
A defect in Pegasystems’ code or rules: Additional space is being introduced, due to wich data is interpreted inconsistely while using BI tools.
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.