Question

1
Replies
1272
Views
ANIRUDH12345 Member since 2011 6 posts
Synechron
Posted: June 27, 2016
Last activity: June 28, 2016
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
Share this page LinkedIn