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

Workflow

Input

Accepted answers

danilang

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

All comments

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

Hi @Tanai_Goncalves

When you read the data as a csv file, you can specify the code page to use.

Dan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703