Shell Programming and Scripting

CHKTHESE="GGS_LOG_SEQ  GGS_ORACREC_SCN GGS_LOG_POS GGS_COMMIT_CHAR"
rm -rf $CHKTHESE final.txt tmp result.txt
cat file >final.txt
for lookfor in $CHKTHESE
do
grep $lookfor file > $lookfor
grep -v $lookfor final.txt > tmp
cat tmp>final.txt
done
cat $CHKTHESE final.txt > result.txt
rm -rf $CHKTHESE final.txt tmp
echo "result.txt will have all data"
cat result.txt

awk -v order="GGS_LOG_SEQ,GGS_ORACREC_SCN,GGS_LOG_POS,GGS_COMMIT_CHAR" '
BEGIN {
   FS = "|";
   OtherKey = SUBSEP;

   Keys_cnt = split(order, Key, /,/);
   Key[++Keys_cnt] = OtherKey;

   for (i=1; i<=Keys_cnt; i++) Key_lines[Key[i]] = "";
}
{
   k = ($2 in Key_lines ? $2 : OtherKey);
   Key_lines[k] = Key_lines[k] $0 ORS;
}
END {
   for (i=1; i<=Keys_cnt; i++) {
      k = Key[i]
      lines = Key_lines[k]
      if (lines) printf "%s",lines;
   }
}
'input_file

number|CREDIT_ID|NULL
date|SYS_CREATION_DATE|NULL
varchar2|GGS_COMMIT_CHAR|NULL
varchar2|GGS_OP_TYPE|NULL
number|GGS_SCN|NULL|
number|GGS_LOG_SEQ|NULL
number|GGS_LOG_POS|NULL
number|GGS_ORACREC_SCN|NULL
varchar2|BATCH_ID|NULL
char|GGS_IMAGE_TYPE|NULL

number|GGS_LOG_SEQ|NULL
number|GGS_ORACREC_SCN|NULL
number|GGS_LOG_POS|NULL
varchar2|GGS_COMMIT_CHAR|NULL
number|CREDIT_ID|NULL
date|SYS_CREATION_DATE|NULL
varchar2|GGS_OP_TYPE|NULL
number|GGS_SCN|NULL|
varchar2|BATCH_ID|NULL
char|GGS_IMAGE_TYPE|NULL
$