Due to misconfiguration of accounting journals

because I set up the default debit and credit accounts for the journal with the same account

I got numerous erroneous entries:

for instance a bank journal created entries where the debited and the credited accounts are the bank account , instead of debit on bank and credit on clients. Now I need to correct this poor situation for a lots of entries.

I can't afford to do this one by one.

How can I export the confirmed status for a whole lot of such erroneous entries and change them to non confirmed with one global operation? Is this the best way to make the corrections?