Script to generate a template orderby.txt when tablesplitting is used for a SAP R3load export

generate_orderby_export.sh

#!/usr/bin/sh
SID=$1
cd /migration/$SID/export/DUMP/ABAP/DATA
list=$(ls -la *.WHR | awk -F ' ' '{print $9}' | sed -e 's/\.WHR//g')
prev_table=""
for l in $list
do
  table=$(echo $l | sed -e "s/-.*//g")
  tableu=$(echo $table | tr '[a-z]' '[A-Z]')
  if (test "$prev_table" != "$table") then
    echo
    echo "[""$tableu""]"
    tablepost="$tableu""-"
    num_splits=$(ls -la *.WHR | grep "$tablepost" | wc -l | sed -e 's/ //g')
    echo "jobNum=$num_splits"
  fi
   echo $l
   prev_table=$table
done