Are you just trying to update old records? I'm confused at what you are trying to do I guess.
If you are just trying to update the database for existing records to strip out the transaction id, then you could do it by looping through the recordset and updating the existing fields creating a custom php script. This is something I could help with in a premier support ticket.