bank-export-wave-import.py

with open("import.txt") as file:
    data = file.read()
    lines = data.split("\n")

with open("export.csv", "w") as output:

    output.write("date, amount, desc\n")

    year = "19"
    balance = 8698.05

    for line in lines:
        first_split = line.split(" " + year, 1)
        date = first_split[0].strip() + " " + year
        sec_split = first_split[1].split("$")
        desc = sec_split[0].strip().replace(",", " ")

        line_balance = float(sec_split[2].strip().replace(",", ""))

        if line_balance > balance:
            amount = "$" + sec_split[1].strip().replace(",", "")
        else:
            amount = "-$" + sec_split[1].strip().replace(",", "")

        # print(balance, amount, line_balance)

        balance = line_balance

        output.write("{0}, {1}, {2}\n".format(date, amount, desc))