scripts/filter-transactions.sh at master · jeroenvanmaanen/scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
#!/bin/bash

set -e

BIN="$(cd "$(dirname "$0")" ; pwd)"

source "${BIN}/verbose.sh"

SED_EXT=-r
case $(uname) in
Darwin*)
	SED_EXT=-E
esac
export SED_EXT

if [ ".$1" = '.--help' ]
then
	echo "Usage: $(basename "$0") [ <field-number> <pattern> ] ..." >&2
	exit 0
fi

declare -a SED_ARGS
SED_ARGS=()

ACCOUNTS_FILE="${HOME}/project/~prive/accounts.csv"
if [ -e "${ACCOUNTS_FILE}" ]
then
	while
		IFS='	' read ACCOUNT CODE DESCRIPTION
	do
		log "ACCOUNT=[${ACCOUNT}]"
		log "CODE=[${CODE}]"
		log "DESCRIPTION=[${DESCRIPTION}]"
		SED_ARGS[${#SED_ARGS[@]}]='-e'
##		SED_ARGS[${#SED_ARGS[@]}]="s/([|][0-9]*[[][34]:[^:]:[0-9]*: )${ACCOUNT}[|]/\1${CODE}|/g"
		SED_ARGS[${#SED_ARGS[@]}]="s/${ACCOUNT}/${CODE}/g"
	done < "${ACCOUNTS_FILE}"
fi

while [ -n "$1" ]
do
	SED_ARGS[${#SED_ARGS[@]}]='-e'
	FIELD="$1"
	POSITIVE="$(expr ".${FIELD}" : '.-\([0-9]*\)' || true)"
	if [ -z "${POSITIVE}" ]
	then
		SED_ARGS[${#SED_ARGS[@]}]="/[|][0-9]*[[]${FIELD}:[^]]*[]]:[0-9]*: ($2)/!d"
	else
		SED_ARGS[${#SED_ARGS[@]}]="/[|][0-9]*[[]${POSITIVE}:[^]]*[]]:[0-9]*: ($2)/d"
	fi
	shift
	shift
done

for SED_ARG in "${SED_ARGS[@]}"
do
	log "SED_ARG=[${SED_ARG}]" >&2
done

tr '\011,.' ',. ' < triodos-and-ing.csv \
	| csv-to-flat.sh \
	| sed -e 's/^$/|/' \
	| tr '|\012' '\012|' \
	| sed "${SED_EXT}" "${SED_ARGS[@]}" \
	| tr '|\012' '\012|' \
	| sed -e 's/^[|]$//'