Posted: 20 Dec 2016 16:20 EST Last activity: 1 Feb 2017 13:42 EST
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?
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.
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.