Shell Programming and Scripting

name  Nx_8977  Nx_988  NN
a1  2  0  8
b1  2  0  8

name  NN
a1  8
b1  8

~/tmp$ cat x.awk
NR==1 {
   for (i=1;i<=NF;i++) {
      if ($i !~ /^Nx_/) {
         output_cols[i]
      }
   }
}
{
   for (i=1;i<=NF;i++) {
      if (i in output_cols) {
         printf $i OFS
      }
   }
   printf "\n"
}
~/tmp$ awk -f x.awk file
name NN
a1 8
b1 8

awk '
NR == 1 {
	for(i = 1; i <= NF; i++)
		if($i !~ /^Nx_/)
			of[++ofc] = i
}
{	for(i = 1; i <= ofc; i++)
		printf("%s%s", $of[i], i == ofc ? "" : "  ")
	print ""
}' file1

name  NN
a1  8
b1  8

		printf("%s%s", $of[i], i == ofc ? "" : "  ")
	print ""

		printf("%s%s", $of[i], i == ofc ? "\n" : "  ")

#!/bin/sh
# cols.sh
echo "name  Nx_8977  Nx_988  NN
a1  2  0  8
b1  2  0  8" > /tmp/filename
temp=""
text=""
while read line
do
	temp=($line)
	text="$text${temp[0]}  ${temp[3]}\n"
	#text="$text${temp[0]}\t${temp[3]}\n"
done < /tmp/filename
printf "$text" > /tmp/newfilename
cat < /tmp/newfilename

Last login: Wed Apr  2 19:06:23 on ttys000
AMIGA:barrywalker~> chmod 755 cols.sh
AMIGA:barrywalker~> ./cols.sh
name  NN
a1  8
b1  8
AMIGA:barrywalker~> _