How to change BIX Delimiter for CSV?
We have Pega-BIX-07-10-13 and exploring to change the delimeter to any other character like # or ] since the many fields contain comma and it ruins the CSV. Also if anyone can help with removing Quotes coming with each value in CSV. How can we remove Quotes in CSV?
Thanks - Haroon
Accepted Solution
Pegasystems Inc.
IN
I dont think it can be changed in the lower version . That is why it has been taken up as enhancement and provided as a feature in the newer releases.
Blue Rose Technologies GmbH
BE
Hi,
Please refer https://community.pega.com/support/support-articles/delimiter-be-changed-csv-generated-bix
Thanks.
Pegasystems
IN
The execution of BIX extracts in an agent via the pxExtractDataWithArgs activity is only supported from Pega 7.1.8 onwards. If you use this activity, then you can pass the -l option to change the demiliter.
Pegasystems
IN
The BIX user guide (bundled with the BIX image) provides the command line parameters that can be used. Note that the same is not available when executing the rule from designer studio.
Pegasystems
IN
This cannot be overridden in an activity. You will need to upgrade to Pega (and BIX) 7.1.8 (at least) to start using the pxExtractDataWithArgs activity which can take -l as an argument to change the delimiter for your CSV extracts.
Rulesware LLC
US
Since I dont have 7.1.8, it means (,) delimiter can't be changed by overwriting the code. How about removing double quotes attached with each field in CSV?
Accepted Solution
Pegasystems Inc.
IN
I dont think it can be changed in the lower version . That is why it has been taken up as enhancement and provided as a feature in the newer releases.
Pegasystems Inc.
IN
Double quotes cannot be removed. If you do not want the double quotes in a CSV file, you'd have to do that with some tool downstream of PRPC and BIX.