Remove attributes from XML using sed

Question

First of all, there might be other (better) options, but I'm bound to sed of awk in this case. I have an XML file with the following contents.

<Field name="field1" type="String">AAAA</Field>
<Field name="field2" type="Integer">0</Field>
<Field name="field4" type="String">BBBB</Field>

Here I would like to change the contents using sed, to get the following result:

<field1>AAAA</field1>
<field2>0</field2>
<field4>BBBB</field4>

So remove the "*Field name="*", the last quote from the name and the rest of the attributes up till the *>* and also I would like to change the last </Field> with the actual field name. How to approach with awk or sed?

Removing from the first tag works with

sed 's/ type=".*"//' 
# and
sed 's/Field name="//' 

I'm not sure how to proceed with the replacing of the last one.

Answer 1

Using sed

$ sed -E 's~[A-Z][^"]*"([^"]*)[^>]*([^/]*/)[^>]*~\1\2\1~' input_file
<field1>AAAA</field1>
<field2>0</field2>
<field4>BBBB</field4>

Answer 2

Another sed:

sed -E 's/^[^"]+"([^"]+)("[^"]+){2}">([^<]+).*$/<\1>\3<\/\1>/' file.xml