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

 Anirudh Yemula (ANIRUDH12345)
Synechron

Synechron
US
ANIRUDH12345 Member since 2011 6 posts
Synechron
Posted: Jun 27, 2016
Last activity: Jun 28, 2016
Posted: 27 Jun 2016 18:37 EDT
Last activity: 28 Jun 2016 5:37 EDT
Closed

How to handle comma values in BIX extract file if we output is in CSV format

created a BIX extract with output as a Comma Separated Values (CSV) and included few properties. Some of the columns that were extracted have embedded commas. When the embedded comma is present, then values appear in the wrong columns as the comma separated ones are split into multiple columns and shift other values over.

For reference see columns 554 and 555 in the attachment.

To see attachments, please log in.
Reporting

Posted: 8 years ago
Posted: 28 Jun 2016 5:37 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

BIX generates CSV files in RFC 4180 format. Any CSV parser that supports this RFC, should be able to handle the comma present in the values as well.

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