Expression Engine - Remove   from field?

Im using channel tags to display content for an RSS feed. The is开发者_StackOverflow社区sue is that the content has been imported and contains  , which makes the feed fail validation and screws up in some readers.

Is their a way to strip out the  ? I've 2 modules that can strip out markup but neither can remove the   http://supergeekery.com/geekblog/comments/expression_engine_2_plugin_supergeekery_tag_stripper_version_1.0 http://devot-ee.com/add-ons/html-plugin

Could this be done with some custom PHP? Thanks

This answer on a similar question should help. Just run this query on the database to get rid of the non-breaking spaces altogether. (Use phpMyAdmin or similar.)

UPDATE exp_channel_data SET text_column = REPLACE(field_id_XX, ' ', ' ')

Replace field_id_XX with the actual name of your column(s).