Bix Output of data with embedded comma's question.
One of our projects is outputting data via bix in CSV format. The problem is, the data apparently has embedded commas. Is there a easy way to avoid the miss-interpretation that follows? Like convert all "." to " " ? Or switch to XML output?
Posted: 4 years ago
Posted: 4 years ago
Thank you very much! I forgot about that. I will present that to the data people, to see if this will work.
Accepted Solution
Posted: 4 years ago
BIX CSV is in RFC-4180 format. If your parser can work with this RFC, then you should not have any issues.
Hi Ivan,
It depends a bit on what version is in use and how exactly you're running BIX. If you're running BIX from the command line, you could use the -l (lowercase L) parameter to change the delimiter:
This screen shot is from the latest BIX User guide:
https://pdn.pega.com/documents/bix-72-user-guide