Hello,
I have a .txt file from which I need to extract some data.
I need the following:
- account which is after ":25:/" - in this case FR73RDGC5482742933543197
- the opening balance which is after ":60F" and after the currency, in this case the opening balance is 70946035,10. To be noted that there are cases when it is either 60F or 60M.
- the closing balance which is after ":62M" and after the currency, in this case the closing balance is 70284085,42. To be noted that there are cases when it is either 62F or 62M.
- the currency, which is before the opening/closing balance, in this case RON
I need these populated in 4 columns in Excel: Account, Opening balance, Closing Balance and CCY
I have files where there are multiple accounts with opening and closing balances put one after another, so I should be comfortable that the right balances are taken for each account.
I attached the txt file below.
I would highly appreciate your help.
Thanks!
I have a .txt file from which I need to extract some data.
I need the following:
- account which is after ":25:/" - in this case FR73RDGC5482742933543197
- the opening balance which is after ":60F" and after the currency, in this case the opening balance is 70946035,10. To be noted that there are cases when it is either 60F or 60M.
- the closing balance which is after ":62M" and after the currency, in this case the closing balance is 70284085,42. To be noted that there are cases when it is either 62F or 62M.
- the currency, which is before the opening/closing balance, in this case RON
I need these populated in 4 columns in Excel: Account, Opening balance, Closing Balance and CCY
I have files where there are multiple accounts with opening and closing balances put one after another, so I should be comfortable that the right balances are taken for each account.
I attached the txt file below.
I would highly appreciate your help.
Thanks!