WordPress.org

1. imekul
   Member
   Posted 1 year ago #

   I have nearly 3,000 posts that I have converted from my own hand-coded blog and into WordPress. Unfortunately, some of the entries have some HTML markup for fonts, colors, paragraphs, and the like.

   Currently, the only way I know of to fix them is to manually edit each post, and essentially strip all formatting, making it plain text.

   This works, but obviously it is quite a chore with thousands of posts. Any idea of a faster way to do this?

   Even if there were a better editor -- say, if I could edit from the display, or if I could load up multiple posts at once to edit -- that would revolutionize things. But it's a little tricky to have to go to each post, click "Edit," make the changes, and hit "Save."

   Any suggestions? Either a semi-automatic way of basically stripping these posts or an easier way for me to edit them by hand would be terrific!

   Thanks.

2. mercime
   Member
   Posted 1 year ago #

   Export XML from WordPress installation.
   Edit XML file "Find and Replace" <font..>, colors, etc. to empty space.
   Go to phpMyAdmin and drop tables from database.
   Reinstall WordPress in browser.
   After set up, import revised XML.
   Good luck.

3. NC@WP
   Member
   Posted 1 year ago #

   That should be pretty simple if you can code in PHP...

   All you need to do is to write a simple script that would connect to WordPress database, retrieve one post at a time from the wp_posts table, run strip_tags() on the content (the post_content field) and write it back into the database.

   To be safe, be sure to export your blog into WXR before you start playing around with your data, just in case you mess something up and want to restore...

Topic Closed

This topic has been closed to new replies.