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?
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:
UHG
US
Thank you very much! I forgot about that. I will present that to the data people, to see if this will work.
Accepted Solution
Pegasystems
IN
BIX CSV is in RFC-4180 format. If your parser can work with this RFC, then you should not have any issues.