XML - UTF problem

[Tanai_Goncalves]

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

[JoaoLeiteV]

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.

[danilang · Accepted solution]

Hi @Tanai_Goncalves 

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 

[priya_mohana_dhl]

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.

[priya_mohana_dhl]

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.