topic Re: Handling Special characters in xml data in QlikView

Handling Special characters in xml data

Wed, 18 Dec 2013 14:26:32 GMT

Hi,

I am working on reading an xml file into my Qlikview App and the data contains special characters such as the ç and the registered trademark symbol. When trying to load these values into the Qlikview App, I am getting a message of:

An invalid character was found in text content.

On line number: 26. On column number: 2070.

Is there a way of handling these special characters when reading data from an xml file?

Thanks

Re: Handling Special characters in xml data

Mon, 13 Jan 2014 17:15:54 GMT

Hi Nielsh,

I have the same type of problem when I am reading the xml code from a qvd.

Did you got any responce yet??

Regards,

Re: Handling Special characters in xml data

Mon, 13 Jan 2014 20:46:58 GMT

Try with ASCII no instead of special character.

Re: Handling Special characters in xml data

Tue, 14 Jan 2014 11:09:59 GMT

Yes, but how can track down which special character causes the issue???

Re: Handling Special characters in xml data

richard — Tue, 14 Jan 2014 11:18:23 GMT

These links might be of great help!

http://www.liquid-technologies.com/XML/EscapingData.aspx

http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references

Re: Handling Special characters in xml data

Tue, 14 Jan 2014 13:18:32 GMT

Hi Nikos,

The only way I could get Qlikview to read the file was by changing the character set from utf-8 to windows-1252 in the xml file. It looks like some of the characters which were in the xml file were not utf-8 compliant.

Thanks

Nilesh

Re: Handling Special characters in xml data

Clever_Anjos — Wed, 15 Jan 2014 23:18:47 GMT

Please assure that is the first line of your xml

<?xml version='1.0' encoding='UTF-8'?>