Question

1
Replies
1285
Views
Anirudh Yemula (ANIRUDH12345)
Synechron

Synechron
US
ANIRUDH12345 Member since 2011 6 posts
Synechron
Posted: June 27, 2016
Last activity: June 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.

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.