SpreadsheetDisassembler CSV to XML not handling ampersands correctly

Posted by: jkohlhepp on 3 August 2017, 5:34 am EST

  • Posted 3 August 2017, 5:34 am EST

    I have a BizTalk process using SpreadsheetDisassembler (version 3.0.6.2008) 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?

    Thanks. 

  • Replied 3 August 2017, 5:34 am EST

    This behavior is by design. While converting from CSV to XML, Spread DisAssembler component does not escapes the special characters as those characters could be valid characters in the resultant XML file.

    We already have a feature request in our system to provide this functionality however as of now I have no exact time frame by which this would be implemented...

    I apologize as I could not provide a better answer on this.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels