What’s New?
-
Enforcing Correct Escaping of Special Characters in Inbound XML Documents
When an inbound XML file is transformed to CSV, it will not be processed if it contains characters that require escaping for the CSV format. These include quotation marks and commas. Where XML data is received that contains non-escaped characters, the document will not be processed, and the sender will be notified by email
Double quotes intended as part of data must be escaped by preceding them with another double quote.
For example
Tomato pizza 9" thick crust
should be sent as either
Tomato pizza 9"" thick crust
or"Tomato pizza 9"" thick crust"
If text data contains commas, it should be enclosed in double quotes.
For example:
"Tomato, pizza 9"" thick crust"
The escaping of commas and double quotes can be sense-checked with the following rule:
Any field that contains double quote characters should always contain an even number of them.
For more information on Trade Simple XML Specifications, please see here.
Release date: 20th October 2025
Comments
Please sign in to leave a comment.