38 lines
997 B
Bash
38 lines
997 B
Bash
#!/bin/bash
|
|
# script to convert pdf bank statements to
|
|
# csv files
|
|
|
|
# these files may have
|
|
# white space in files names
|
|
while IFS='' read -r -d '' fname ; do
|
|
nname="${fname##*/}"
|
|
mv -v -n "${fname}" "${fname%/*}/${nname//[[:space:]]/_}"
|
|
done < <(find "$(pwd)" -name "* *" -type f -print0)
|
|
|
|
rm -rf dd.txt
|
|
a=`ls *.pdf`
|
|
|
|
for l in $a;
|
|
do
|
|
echo "processing" $l
|
|
ps2ascii $l >> dd.txt;
|
|
done
|
|
view dd.txt
|
|
cat dd.txt | sed -n '/.*[0-9][0-9] \+[A-Z][a-z][a-z]/p' \
|
|
| sed 's/\([0-9]\+\),\([0-9]\+\)/\1\2/g' \
|
|
> ddd.txt
|
|
|
|
view ddd.txt
|
|
|
|
vi m_spreadsheet.txt
|
|
cat m_spreadsheet.txt | sed 's/\(Opening balance\)/,,,,,,,\1/' \
|
|
| sed 's/\(Statement period\)/,,,,,,,\1/' \
|
|
| sed 's/\(DR INTEREST\)/,,,,,,,\1/' \
|
|
| sed 's/\(MONTHLY ACCOUNT FEE\)/,,,,,,,\1/' \
|
|
| sed 's/\([0-9]\+\.[0-9]\+\) OD/\1,OD/' \
|
|
| sed 's/.*\([0-9][0-9] \+[A-Z][a-z][a-z]\) \+\([A-Z][A-Z]\)/\1,\2/' \
|
|
| sed 's/\(Your accounts at a glance as at\)/,,,,,,,\1/' > m_spreadsheet.csv
|
|
#
|
|
view m_spreadsheet.csv
|
|
#
|