graphical mapping issue

Hi Gurus

actual i have a like following input structure

<ROOT>

<NODE>

<ID>100</ID>

<VALUE>12386EUR120,00</VALUE>

</NODE>

<NODE>

<ID>200</ID>

<VALUE>ASDFGHJEUR156320,00</VALUE>

</NODE>

</ROOT>

and needed output structure is

<ROOT>

<NODE>

<WAERQ>EUR</WAERQ>

<SUMME>120,00</SUMME>

</NODE>

<NODE>

<WAERQ>USD</WAERQ>

<SUMME>156320,00</SUMME>

</NODE>

</ROOT>

how can we substract the value after currency?

Thank you