Merge and clean Nordea account statements

Makefile

PK_CSV_FILES=$(wildcard **/personkonto_*.csv)

.PHONY: default clean

default: personkonto.csv

personkonto.csv: $(PK_CSV_FILES)
	@echo '"Datum","Transaktion","Kategori","Belopp","Saldo"' > $@
	@cat $^ | sed -n -e 's/"\?Datum"\?.\+//' \
		-e 's/\.\([0-9][0-9][0-9]\)/\1/g' \
		-e 's/"\(-\?\)\([0-9]\+\),\([0-9][0-9]\)"/\1\2.\3/g' \
		-e '/^\S/p' \
		| sort >> $@

clean:
	@rm -f personkonto.csv