#!/bin/sh

TXT_FILEPATH=$1
ROW_NUMBER=$(wc -l ${TXT_FILEPATH}.txt | awk '{ print $1 }')
ROW_NUMBER=$((ROW_NUMBER - 2))
RAW_DATA=$(cat ${TXT_FILEPATH}.txt | tail -n ${ROW_NUMBER})

echo "TableName, RowNumber" > $1.csv

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