hledger journal cleanup script

journalcleanup.py

inputFile          = 'input.journal'
outputFile         = 'output.journal'
alignColumn        = 100
decimalSeparator   = ','
addMissingDecimals = True

with open(inputFile, 'r') as file_input, open(outputFile, 'w') as file_output:
    for line in file_input:
        if line.strip().startswith(("assets:", "expenses:", "revenues:", "liabilities:")):
            account, amount_comment = line.rsplit('  ', 1) 
            
            amount_comment = amount_comment.strip();
            
            comment = ''
            
            if ';' not in amount_comment:
                amount = amount_comment.strip()
            else:
                amount_comment_split = amount_comment.split(';')
                amount = amount_comment_split[0].strip()
                comment = ' ; ' + amount_comment_split[1].strip()
            	
            if addMissingDecimals and amount != '' and decimalSeparator not in amount:
            	amount += decimalSeparator + '00'
            	
            spaces = alignColumn - 1 - len(account) - len(amount)
            
            newline = f"{account}{' ' * spaces}{amount}{comment}\n" 
            file_output.write(newline)  
        else:
            file_output.write(line)