Remove illegal caracters in XML SAP MII

[former_member602445]

Hi everyone.

I need your help for know (if it's posible) how to remove illegal caracters, in xml SAP MII v. 15.1 before insert in Data Base (SQL Server)

The xml is:

<?xml version="1.0" encoding="UTF-8"?>

<item>
<code_material>000000000030012709</code_material>
<material_type>ZROD</material_type>
<material_group>A0033</material_group>
<measure_unit_base>UDC</measure_unit_base>
<measure_unit_order/>
<plant>XXXX</plant>
<desc_material>MATERáL DESCRIPTIÓN Ñ</desc_material>
<comp_desc_material>MATERIáL DESCRIPTIÓN Ñ</comp_desc_material>
<consumption_type>TOTAL</consumption_type>
</item>

Thank you for your help

[former_member185280]

I would probably try to do it with an xsl using the translate function.

Regards,
Christian