Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
Try with ASCII no instead of special character.
Yes, but how can track down which special character causes the issue???
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
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
Please assure that is the first line of your xml
<?xml version='1.0' encoding='UTF-8'?>