Script to modify .csv Credit Card Transactions of DKB for use with GNUCash

dkbcc.py

import re, sys, os

if __name__ == '__main__':

    filePath = os.path.abspath(sys.argv[1])
    print("Reading %s"%str(filePath))
    with open(filePath, 'r', errors='ignore') as f:
        data = f.read()
        print(data)
    with open(filePath, 'w') as f:
        searchString = r'(\d{2})\.(\d{2})\.(\d{4})'
        replaceString = r'\g<3>-\g<2>-\g<1>'
        data = re.sub(searchString, replaceString, data)
        searchString = r','
        replaceString = r'.'
        data = re.sub(searchString, replaceString, data)
        f.write(data)