Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Ivan Peters (IvanP276)
UHG

UHG
US
IvanP276 Member since 2015 6 posts
UHG
Posted: May 20, 2016
Last activity: May 27, 2016
Posted: 20 May 2016 15:49 EDT
Last activity: 27 May 2016 7:57 EDT
Closed
Solved

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?

To see attachments, please log in.
Reporting

Posted: 8 years ago
Posted: 20 May 2016 16:19 EDT
Loving (NicholasLoving)

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://docs-previous.pega.com/bix-72-user-guide

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 27 May 2016 7:57 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

BIX CSV is in RFC-4180 format. If your parser can work with this RFC, then you should not have any issues.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice