UNIX for Dummies Questions & Answers

fromdos file

tr -d '\r' < file > newfile

cat code.awk 
BEGIN{
  FS=OFS="\t"
}

{ 
  print
}

NR==1{
  getline < secondfile
  for (i=2;i<=NF;i++) Label[$i]=i
  for (i=2;i<=NF;i++) Order[i]=Label[$i]
  next
} 

{
  getline < secondfile
  $1=""
  split($0,Field)
  for(i=2;i<=NF;i++) $Order[i]=Field[i]
  print
}

$ awk -f code.awk secondfile=file2.txt file1.txt

$ cat code2
#!/bin/sh
[ $# -eq 2 ] || { echo "Usage: ${0##*/} file1 file2" >&2; exit 1 ;}

awk '
BEGIN{
  FS=OFS="\t"
}

{ 
  print
}

NR==1{
  getline < secondfile
  for (i=2;i<=NF;i++) Label[$i]=i
  for (i=2;i<=NF;i++) Order[i]=Label[$i]
  next
} 

{
  getline < secondfile
  $1=""
  split($0,Field)
  for(i=2;i<=NF;i++) $Order[i]=Field[i]
  print
}
' secondfile="$2" "$1"

$ ./code2 file1.txt file2.txt