#! /bin/sh
echo -n "Name database input file: ";read dn
for i in `ls -1 *.dat`
do
echo $i

# Parse data
vehicle=$(cat $i | grep "50|10|" | cut -d \| -f 3)
mileage=$(cat $i | grep "50|15|" | cut -d \| -f 3)
date=$(cat $i | grep "50|17|" | cut -d \| -f 3)
quantity=$(cat $i | grep "50|20|" | cut -d \| -f 3 | tr \, \.)
net=$(cat $i | grep "50|21|" | cut -d \| -f 3 | tr \, \.)
tax=$(cat $i | grep "50|25|" | cut -d \| -f 3 | tr \, \.)

# Write SQL instruction file
echo "Insert into fuel values ('$vehicle',$mileage,'$date',$quantity, $net, $tax)" >> $dn