Posted 3 August 2017, 5:34 am EST
I have a BizTalk process using SpreadsheetDisassembler (version 22.214.171.1248) to convert a CSV file into XML. There are cases where ampersands occur in text fields within the CSV. They are unescaped because ampersand is not a special character for the CSV format. However, the disassembler does not escape the ampersands when converting to XML. Since ampersand *is* a special character in XML format, this causes downstream validation problems on the XML file.
Is there a way to make the SpreadsheetDisassembler properly escape ampersands when converting from CSV to XML? Has this problem been resolved in a newer version?