vebit-map/prepare.sh

16 lines
509 B
Bash
Executable File

#!/usr/bin/env sh
if="../non-public/eV/members.fods"
ofn=$(echo $if|rev|cut -d"/" -f1|cut -d"." -f2-|rev)
fae="file already exists."
# recv data
if test -e $ofn".csv" ; then
echo "$fae"
else
libreoffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":"59,,76,3,1/1/2/2/2" $if || { echo "errors during export to csv"; exit 3; }
tail -n +2 ${ofn}".csv" | cut -d";" -f2,13-17|grep -e "^[v|g|n]" > ${ofn}".tmp"
mv ${ofn}".tmp" ${ofn}".csv" || { echo "error on removing first line."; exit 6; }
fi