remove and clean CDATA out of xml

Hello,

I have a big xml solr feed out of my content management system that
includes wysiwyg html tags inside CDATA tags.

I am looking for a way to remove the CDATA and only get the text.
CURRENT:
<add>
<doc>
<some_title>My title</some_title>
<content><![[CDATA[
<p>The <strong>keyword</strong> is nice to have but is not needed to
include in a solr feed</p><p><table cellspacing="2" cellpadding="2"
border="1" width="100%"><tbody><tr><td>&#201;tape 1&nbsp;:</td></tr>
]]></content>
</doc>
<doc>
....
</doc>
</add>

WANTED:
<add>
<doc>
<some_title>My title</some_title>
<content>The keyword is nice to have but is not needed to
include in a solr feed</content>
</doc>
<doc>
....
</doc>
</add>

any vim tricks to do this?

thx
--
[Bb](astia{2}n)?\s?[Ww](ak{2}ie)?$

--
You received this message from the "vim_use" maillist.
For more information, visit http://www.vim.org/maillist.php