ETL and Data Integration tools - Modern ETL software for everyone

The XML files I need to process are encoded in the UTF-16 character set.
This is not changeable in the application that is creating them.

When trying to process these files with Advanced ETL Processor Pro, I get an error message:

"Invalid XML Element: malformed tag found (no valid name) at position 2"

This message is erroneous. If I retype *exactly* the same text in UTF-8 format then it works fine.

All my my text is standard ASCII, with no complex characters. I do not need to deal with non western character sets. Is there any way I can deal with this within AETL Pro? Even a workaround would be great if it can't deal directly wth UTF-16 then a conversion to a single byte latin character set ISO-8859-1 or UTF-7 would work fine for me.

Using ETL Pro v 4.2.4.13

Andy

Can you zip and post example of the file here and we will do our best to help you

Mike

Thankyou for the fast response. An example file is zipped and attached.

Andy

Our software currently supports utf8 encoding only
We will add support for utf-16 in the next release(it will take 1-2 weeks)

However even if we add support for utf-16 there is a problem with your file

Byte order mark is missing
en.wikipedia.org/wiki/Byte_order_mark

if you have a look at the files here
they do have t
www.w3schools.com/XML/xml_encoding.asp

Mike

Thanks Mike. Reading further into that page, it looks like the identifer bytes at the start of UTF format text are optional:



The first byte is hex 3c which is ascii "<" which would make me think it's correct XML.

Thanks for looking into UTF-16 support, it's appreciated that you are fast moving with regards to user requests and problems.

We will investigate it as well

Mike