- Joined
- Mar 8, 2017
- Messages
- 2
- Reaction score
- 0
- Country
Thanks to your forum, I have just identified a problem that has been happening for years. My bank has been putting the memo in <NAME> field in QIFs and nothing in <MEMO> field. (Consequence: NOTHING was categorised!) I've asked the bank to fix it... but have thousands of transactions to fix.
I can bulk replace the payees by doing an f3 replace. But that will overwrite the transaction details I still need, which should be in the memo fields! So I need to COPY the memos from the Name field to the memo field first.
(I paid people to spend weeks manually copying them, ended in heaps of errors!)
Can anyone help with a way to do that by bulk replace in selected transactions, or hack?
(I can't re-download the transactions, even if the bank does fix it; and in any event I can't delete all my reconciled transactions, hundreds of which have been updated by hand.)
Thanks
I can bulk replace the payees by doing an f3 replace. But that will overwrite the transaction details I still need, which should be in the memo fields! So I need to COPY the memos from the Name field to the memo field first.
(I paid people to spend weeks manually copying them, ended in heaps of errors!)
Can anyone help with a way to do that by bulk replace in selected transactions, or hack?
(I can't re-download the transactions, even if the bank does fix it; and in any event I can't delete all my reconciled transactions, hundreds of which have been updated by hand.)
Thanks
Last edited: