Handling Special characters in xml data

[#1]

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

[#2]

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,

[#3]

Try with ASCII no instead of special character.

[#4]

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

[richard]

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

[#6]

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

[Clever_Anjos]

Please assure that is the first line of your xml

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