Q:

How to handle duplicate attribute names and hexadecimal values

I have an unformatted XML file like this:
<ROOT>
    <A0>Hi</A0>
    <A1 A="hi" A="how" A="are" A="You?"></A1>
    <A2 A2="Bye"> </A2>
    <A3>In this tag have hexadecimal value</A3>
</ROOT>

Questions:

how do I handle duplicate attribute name like in tag <A1> ?
how do I handle hexadecimal values like in tag <A3> ?

I have to use this type of files as a source in a SSIS package.
Thanks

A:

<ROOT>
  <A0>Hi</A0>
  <A1 A="hi" A="how" A="are" A="You?"></A1>
  <A2 A2="Bye"> </A2>
  <A3>In this tag have Hexa deimal value </A3>
</ROOT>

Duplicate attributes (on the same element) are not allowed in a well-formed XML document by definition.
Therefore the provided text isn't an XML document, cannot be parsed by any compliant XML parser -- and therefore, the described problem cannot exist.

