Posted: 13 Sep 2019 8:16 EDT Last activity: 5 Feb 2020 10:39 EST
Need to include values with comma in BIX CSV Extract.
I have below requirement.
Pega is getting JSON message and its getting stored in one of the clipboard property on pyWorkPage. As part of BIX extract (we are using CSV format for BIX extract), this JSON message also needs to be included in it. But since there are comma in JSON message, BIX extract is not getting generated properly. I need to include whole JSON message as single value in BIX exctract.
Has anyone faced this issue earlier. I am using Pega 7.3
***Edited by Moderator: Lochan to update platform capability tags***
Thanks for your reply. I think in this way I will have to inform other application who are going to use BIX extract that replace these keywords again with comma if they need exact same JSON message. I was looking some way so that I can use values in same column with comma itself.
As you are generating CSV file and by default it uses comma(",") as separator so i am not sure if same file can have all the property values separated and one particular property also with commas.
One more option that you can change the delimiter of BIX extract generated from comma to some other special character as a separator (for example |) using -l parameter and specify what character to use instead of a comma.
This approach would also need you to inform other application who are going to use BIX extract. But this approach will be easier as you only need to take care of parsing of values which will be based on "|" instead of ",".