Posted: 27 Jun 2016 18:37 EDT Last activity: 28 Jun 2016 5:37 EDT
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.