How can I use rules to grab fields from one content type to another then delete the old nodes? I have an D7 site using feeds that create dozens of nodes daily populated with RSS articles. I use the body fields from these articles as well so I can read them on-site without clicking to the actual publisher. Means my database is getting bigger. Here's what I want to do:

Any node over 4 weeks old of 'feed' type needs to create a new node called 'feed archive' and do this by using the old title and just the article URL - no other fields need to be transferred. Then the old node can be deleted. So I basically dump all the body content and other fields attached to the old 'feed' node and just leave the title and URL and create a new node with these two things.

I have created a rule using VBO views before so kind of understand that, but don't know how I say: 'create a new node, only grab these two fields from it, then delete it'

Any help greatly appreciated.
In your rule, i think your can write a custom php code:

  //$node is your original node

  $node_new = new stdClass();
  $node_new-&gt;type = 'content_type_2';
  $node_new-&gt;status = 1;
  $node_new-&gt;uid = $node-&gt;uid;
  $node_new-&gt;title = $node-&gt;title;
  $node_new-&gt;promote = 0;
  $node_new-&gt;created = $node-&gt;created;
  $node_new-&gt;timestamp = $node-&gt;timestamp;
  $node_new-&gt;field_article_url = $node-&gt;field_article_url;

  node_save( $node_new );
  node_delete( $node );