Coldfusion - formatting an XML string returned from an API call

Question

We call an API that returns a string of XML-formatted data. We would like to convert this string to a ColdFusion XML object through XMLParse (). A problem occurs when special characters are displayed in data values. For example, such characters:

  — –

(yes, the source data contains them in an equivalent encoded in HTML). When executing XMLParse (), it generates an error for these encoded characters. Here is an example that will result in an error:

Part of our line: <event>Hello &nbsp; World</event>

Mistake: Reference to undefined entity " "

What is the best way to make these characters compatible with XMLParse ()? And more importantly, how can we do this if we do not always know what the symbols will be?

Thanks!

(this is on ColdFusion 6 server)

Answer 1

:

ReplaceList(xml, " ,—,–", "#Chr(160)#,#Chr(8212)#,#Chr(8211)#")

, , char. Chr() , , .

Answer 2

replace(xml, '&','&','all');

. DTD , , , , - , , .

Answer 3

, , HTML.

http://www.petefreitag.com/item/202.cfm

Answer 4

: HTML ColdFusion?

, XmlFormat(), XmlParse().

"nbsp 5 ", @stevenerat.

Answer 5

Yup, nbsp xmlformat(), xmlparse (xmlformat (theString)).

http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references http://livedocs.adobe.com/coldfusion/7/htmldocs/00000668.htm

Answer 6

Replacing "&" with "&"and then again after parsing seems to work

<cfsavecontent variable="xmlString">
    <event>Hello&nbsp;World&amp;</event>
</cfsavecontent>
<cfset xmlString = Replace(xmlString, "&", "&amp;", "all") />
<cfset doc = Xmlparse(xmlString) />
<cfset value = Replace(doc.event.xmlText, "&amp;", "&","all") />

Answer 7

You can take a look at XmlFormat () . Easy to use:

<cfset string = XmlFormat(string)>