Shell Programming and Scripting

NAME|ABC|LASTNAME|PQR|AGE|20|SEX|MALE|
NAME|XYZ|LASTNAME|PDF|AGE|21|SEX|MALE|

NAME    ABC
LASTNAME   PQR
AGE      20
SEX      MALE
 
NAME    XYZ
LASTNAME   PDF
AGE      21
SEX      MALE    etc....

#!/usr/bin/ksh
FileName=INPUT_FILE.txt

if [[ -e $FileName ]]; then
while read line
  do
    awk -F |  '{for( i = 1;i <= NF;++i)
      if( i % 2 == 0 ) printf("%s\n",$i) 
    else
      printf("%s|",$i) ; }'
  done < $FileName
else
   echo "File $FileName  does not exists"
fi

sed ':a;s/|/ /;s/|/\n/;ta' infile

$ cat cmd
:a
s/|/ /
s/|/\
/
t a
$ sed -f cmd file
NAME ABC
LASTNAME PQR
AGE 20
SEX MALE

NAME XYZ
LASTNAME PDF
AGE 21
SEX MALE

perl -wpl -e 'while (/\|/) { ++$i ; if ($i%2) {s/\|/\t/}  else {s/\|/\n/} ; }'infile.txt

sed -e :a -e 's/|/ /' -e 's/|/\n/' -e ta infile