Skip to content

Instantly share code, notes, and snippets.

@timabell

timabell/fix-metro.sh

Created April 3, 2018 19:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timabell/e1ed91925701e0125dd48f11628086d5 to your computer and use it in GitHub Desktop.
Save timabell/e1ed91925701e0125dd48f11628086d5 to your computer and use it in GitHub Desktop.
Download ZIP
metro bank export to ynab import converter
Raw
fix-metro.sh
#!/bin/bash
IFS='\n'
for x in *.csv; do
echo "$x"
cp "$x" "$x.orig"
sed -i '1c Date,Payee,Memo,Money In, Money Out,Balance' "$x"
# remove stupid date from start of tx description. fucking idiots.
sed -i 's/,[0-9][0-9] [A-Z][A-Z][A-Z] [0-9][0-9] /,/g' "$x"
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment