Solution for clean product description schema / text

[BoKr]

At the point in time when we started with Prestashop we had product descriptions prewritten in MS Word. We then copied the text into Prestashop.

This was no good practice.

​

​Now I have problems to clear html markup or code. When I do a SQL export then this markup is not exported. I can see it via Prestools/Tripleedit or directly in the DB. Worse, Google (Shopping) can see it too.

​So, I need to clean it. Best via batch or search & replace.

​

​examples

<p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="color: #00000a;"><span style="font-family: 'Arial','sans-serif'; mso-bidi-font-family: Mangal;">Doppelstö...</span><!--?xml:namespace prefix = o 
ns = "urn:schemas-microsoft-com:office:office" ?--></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="color: #00000a;"> </span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: 'Arial','sans-serif'; mso-bidi-font-family: Mangal;"><span style="color: #00000a;">Ein w.....</span></span></p>

​or

<p> </p>
<p></p>
<p><span style="font-size: small;">

mh have a loot at the screenshot attached please:

​

​