$cat all.sh
#!/bin/sh

FILES=$(ls $1/*.txt)

for f in $FILES; do
    echo "sh find_table_row.sh $f"
    sh find_table_row.sh $f
done

$cat find_table_row.sh
#!/bin/sh

FULLPATH=$1
FILENAME=${FULLPATH%.*}

ROW_NUMBER=$(wc -l ${FILENAME}.txt | awk '{ print $1 }')
ROW_NUMBER=$((ROW_NUMBER - 2))

RAW_DATA=$(cat ${FILENAME}.txt | tail -n ${ROW_NUMBER})

echo "TableName, RowNumber" > ${FILENAME}.csv

echo "${RAW_DATA}" | awk '{ printf "%s, %s\n", $1, $7 }' >> ${FILENAME}.csv