RegEx help

[MK97pro]

Dear Community,

could you please help me with RegEx formula because I cannot find a solution to replace some part of the string:

Outer_XML

<jed:Bilans

<jed1:Aktywa

<def:KwotaA

95423752.03</def:KwotaA

<def:KwotaB

73549705.78</def:KwotaB

<jed1:Aktywa_A

<def:KwotaA

28123841.83</def:KwotaA

In some places I have string such as "jed:" or "def:" and I want to replace it with nothing to have i.e. <Bilans instead of <jed:Bilans as well ass 95423752.03</KwotaA instead of 95423752.03</def:KwotaA

I would be appreciated if you could help!

[PhilipMannering]

What do you want to do with `jed1:`?

[PhilipMannering]

Something like this will get rid of jed: and def: and leave jed1: untouched. 

If that's not what you want, it really helps to include and expected output table