Howdy...

Previously the card was not truncating / munging the credit card numbers if the transaction failed. The latest version of the cart software truncates the credit card even on failed transactions - which is what we wanted. But now we have a bunch of previously/historical failed transactions still with full credit card numbers. The credit card numbers are encrypted in the DB (good) but we'd like to batch process these credit card numbers and truncate them.

Any shortcuts to this process versus manually updating the account numbers?