1 Reply Latest reply on Oct 8, 2014 8:47 AM by BKBK

    how to format a not well formed xml into well formed

    parthu_a1

      Hi,

       

      Here's what I'm trying to do: I have a build a report based on query results. In the query result, one field is a CLOB (which contains XML. The XML contains two tags - "description" and "count"). I want to read (&parse) the XML and store the "description" and "count" in a hashmap. But when I try to parse it, I end up in an error. I'm currently  using XmlParse but I got an error "The markup following the root element should be well formed."  I immediately used IsXml() to find out if the XML I am reading is well formed.  And the answer is "NO".

       

      Could someone help me in converting it into a "well formed" one?

       

      (This is what I've tried: I appended "<?xml version="1.0" encoding="UTF-8"?>" to the XML I'm reading coz it was missing this.  I later used XmlFormat to convert the XML into a string format.  But IsXML tells me that even this is not well formed.)

       

      Thanks much for your help!

        • 1. Re: how to format a not well formed xml into well formed
          BKBK Adobe Community Professional & MVP

          XML encodes information is a specific way. Well-formedness determines whether or not a string is an XML document in the first place.

           

          However, as well-formedness can be broken by any arbitrary number of factors, it is in general impossible to automate the repair process to recover a well-formed XML document. You have to do it manually, using an XML or a text editor.