When we started our website, as completel novices, we were uploading product descriptions in html but inadvertantly had <html></html> tags, with <head></head> and <body></body> tags in the descriptions as well. Now, after 18 months we've realised that these tags need to come out. Mainly, because they're affecting the page layout in certain ads with a drop down menu for attributes and additional images in the same ad. Remove these pointless tags and the problem is cured.

So, we've been trying different ways of bulk editing 4,000 products. Nothing seems to be working though. The first thing we tried (after backing up the BD) was logging into phpMyAdmin and opening the products_description table. Then, we export the sql file for that table and edit it using software, phpDesigner8. CTRL+F all the garbage html with empty space and repeat for all other unwanted tags, save the file and then import. Problem with this is it would take a lifetime. There's just so much of it and I'm sure there will be mistakes along the way which will render the effort pointless.

So, we started to look at Easy Populate. Installed it and downloaded the products as .csv.... After removing all the unwanted <tags> with CTRL+F replace, we try to upload it but it just seems to time out. No error messages, just an egg timer which eventually stops and then nothing, the <tags> are all still there?

Does anyone have a suggestion on how to remove all these unwated html tags?