Good evening,
I'm trying to read several XML Files, but some of them have scpecial character '-'.
When I remove this '-' from the data, the workflow runs fine.
Is there a way to read the XML with special character?
error "UTFDataFormatException"
Kind regards,
Tanai
Solved! Go to Solution.
Hello @Tanai_Goncalves,
Just a quick suggestion, maybe reading the file as a CSV instead of XML would solve your issue, but then you would probably need to adjust some of the parsing you're doing.
When you read the data as a csv file, you can specify the code page to use.
If you can find the correct code page to use the special characters will be converted. After this, use a Summarize tool to concatenate all the rows into a single cell. Follow this with as many XML Parse tools as required to read out the elements you need.
Dan
Hi,
My XML file starts with
<?xml version="1.0"?>
<NSARESPONSE trandate="2022-03-04 16:13:03" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="">
The XML file contains '&' and special characters and reading this XML generates Unterminated entity reference error (Gone after removing &)
Will <?xml version="1.0" encoding="utf-8"?> help to get rid of the special characters like '&'
Thanks.
Hi,
I tried to open an xml using the Input Data tool. The input xml file has <?xml version="1.0"?> in the header.
I replace the xml header with
Then save it as an xml file with this configuration
Even after specifying the Code Page as UTF-8, the special characters are not converted. Any help is appreciated.
Thanks.