Shell Programming and Scripting

table 897     897     490
table1        8642    8642    7127
table1111        888     888     399
table2      50      0
table3      25597   25597   1691
table four       7798    7798    1691
table five       461     461     3513
table6      29      29      152
some_more_table7  30522   30522   1691
yet ANother_last TAble      462     462     3513

FORM='%-20s%8s%8s%8s\n'
split -l 10  Table_data.txt
IFS=',' # use another delimiter if ';' dosn'fit your needs
printf "$FORM" "TABLE NAME" "COUNT 1" "COUNT 2" "COUNT 3"
echo
paste -d "$IFS" Table_Name.txt xaa xab xac | while read A B C D
do    printf "$FORM" "$A" $B $C $D
done

#!/usr/bin/env bash

# @(#) s1	Demonstrate split, paste, align.
# See: http://freshmeat.net/projects/align

# Uncomment to run script as external user.
# export PATH="/usr/local/bin:/usr/bin:/bin"
# Infrastructure details, environment, commands for forum posts. 
set +o nounset
pe() { for i;do printf "%s" "$i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
LC_ALL=C ; LANG=C ; export LC_ALL LANG
echo ; echo "Environment: LC_ALL = $LC_ALL, LANG = $LANG"
echo "(Versions displayed with local utility \"version\")"
c=$( ps | grep $$ | awk '{print $NF}' )
version >/dev/null 2>&1 && s=$(_eat $0 $1) || s=""
[ "$c" = "$s" ] && p="$s" || p="$c"
version >/dev/null 2>&1 && version "=o" $p specimen split paste align
set -o nounset

FILE1=${1-data1}
shift
FILE2=${1-data2}

# Sample data files with head / tail if specimen fails.
echo
specimen $FILE1 $FILE2 \
|| { echo "(head/tail)"; head -n 5 $FILE1 $FILE2; echo " ||" ;\
     tail -n 5 $FILE1 $FILE2; }

# Remove debris from previous runs.
rm xa?

echo
echo " Results:"
# split -l 10  Table_data.txt
# paste Table_Name.txt xaa xab xac
# paste data1 xaa xab xac |
split -l 10 data2
paste data1 xac xab xaa |
align -st

exit 0

% ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 2.6.26-2-amd64, x86_64
Distribution        : Debian GNU/Linux 5.0 
GNU bash 3.2.39
specimen (local) 1.17
split (GNU coreutils) 6.10
paste (GNU coreutils) 6.10
align 1.7.0

Whole: 5:0:5 of 10 lines in file "data1"
table
table1
table1111
table2
table3
table four
table five
table6
some_more_table7
yet ANother_last TAble

Edges: 5:0:5 of 30 lines in file "data2"
490
7127
399
0
1691
   ---
7798
461
29
30522
462

 Results:
table			 897   897   490
table1			8642  8642  7127
table1111		 888   888   399
table2			  50	50     0
table3		       25597 25597  1691
table four		7798  7798  1691
table five		 461   461  3513
table6			  29	29   152
some_more_table7       30522 30522  1691
yet ANother_last TAble	 462   462  3513

table			 897   897   490
table1			8642  8642  7127
table1111		 888   888   399
table2			  50	50     0
table3		       25597 25597  1691
table four		7798  7798  1691
table five		 461   461  3513
table6			  29	29   152
ome_more_table7	       30522 30522  1691
yet ANother_last TAble	 462   462  3513