Bash script, which allows you to add a Index-column to a CSV file, and encode it as UTF-8. You can also add your own seperator. Created, for easy prep of file, before import to Firefly III.

csv-add-index-and-encode.sh

#!/bin/bash

echo ""
if [ -z "${1}" ]; then
    echo "csv-add-index-and-encode: Error!"
    echo "Please define input-file as the first paramter, and optinally define seperator (like ;) as the secound one, like:"
    echo "./csv-fix.sh  NemKonto_PosterinterTest3.csv \";\""
    echo ""
    exit 1
else
  echo "> csv-add-index-and-encode: Let's start"
fi

in=$1
out="final-$1"

encoding_wanted="UTF-8"
current_encoding=`uchardet $1`

seperator=$2

if [ -z "${2}" ]; then
    seperator=";"
    echo "> Seperator not defined, using the default one, which is ';'"
else
    echo "> Using '$2' as seperator"
fi

echo "> Using the following seperator '$seperator'"

#OFC can be used, to define a space after the changed value...
awk -F'\t' -v OFS='' -v sep="$seperator" '
  NR == 1 {print "\"ID\""sep, $0; next}
  {print (NR-1)sep, $0}
' $in  > $out.tmp

echo "> Saved tmp-file as: $out.tmp"
echo "> Index-colum added!"

echo "> Using iconv to change character-encoding to $encoding_wanted. Current encoding: $current_encoding."

iconv --from-code=$current_encoding --to-code=$encoding_wanted $out.tmp > $out

current_encoding=`uchardet $out`
echo "> Encoding done. uchardet now reports the following encoding: $current_encoding"
echo "> Removing $out.tmp ..."
rm $out.tmp
echo "> Result saved as: $out"
echo ""