Hi, I have not very structured text file like:
24 JULY, WEDNESDAY
USD Account
Tax
-92 USD
USD Account
Tax
-51 USD
USD Account
Income
403.15 USD
USD Account
Payout
707.35 USD
08 JULY, MONDAY
USD Account
Purchase
-16 053 USD
Investments
USD Account
Broker comm.
-48.16 USD
Investments
USD Account
Commission
-99 USD
I need to parse it to columns as follows:
| Date | Account | Operation type | Amount | Currency | Tags |
| 24.07.2019 | USD Account | Tax | -92 | USD | |
| 24.07.2019 | USD Account | Tax | -51 | USD | |
| 24.07.2019 | USD Account | Income | 403.15 | USD | |
| 24.07.2019 | USD Account | Income | 707.35 | USD | |
| 08.07.2019 | USD Account | Purchase | -16053 | USD | Investments |
| 08.07.2019 | USD Account | Broker comm. | -48.16 | USD | Investments |
| 08.07.2019 | USD Account | Commission | -99 | USD | |
Is there any way to achieve this using a load script?
