Remove inline CSS from body fields in Drupal.

remove_css

/**
 * For removing inline CSS from body fields in Drupal.
 *
 * -Install devel module.
 * -Navigate to devel/php.
 * -Paste the following code and execute.
 */

$results = db_select('field_data_body', 'f')
  ->fields('f', array('entity_id', 'body_value'))
  ->execute()
  ->fetchAll();

foreach ($results as $result) {
  $body = preg_replace('/(<[^>]*) style=("[^"]+"|\'[^\']+\')([^>]*>)/i', '$1$3', $result->body_value);
  db_update('field_data_body')
    ->fields(array(
      'body_value' => $body,
    ))
    ->condition('entity_id', $result->entity_id)
    ->execute();
}

Thanks!

It would be a good idea to update field revisions as well.