Hi all I downloaded some bank statements in CSV format with a view to providing an automated bank reconciliation feature for my accounting software.
One of them shows the opening balance in an unusual format. Most transaction amounts are in the format '-00000031.23' or '+00000024.58' This can easily be parsed using decimal.Decimal(). If the opening balance is positive, it appears as '+00000021.45' If it is negative, it appears as '+00000-21.45' Predictably, decimal.Decimal does not like this. Is this a recognised format, and is there a standard way of parsing it? If not, I will have to special-case it, but I would prefer to avoid that if possible. Thanks Frank Millman -- https://mail.python.org/mailman/listinfo/python-list