Code:
$ cat base_compare.txt
|| Base Compare
key_NUM || FNL_PIPLN FNL_PIPLN Diff. % Diff
|| _EXIT_DT _EXIT_DT
___________ || _________ _________ _________ _________
||
L0051041044 || 17303 . . .
L0053125829 || 17303 . . .
L0053855466 || 17303 . . .
L0061072864 || 17303 . . .
L0061288205 || 17303 17103 . .
L0062343827 || 17303 17203 . .
L0062526348 || 17303 23201 . .
L0063725295 || 17303 . . .
L0064004237 || 17303 . . .
L0064723026 || 17303 . . .
|| Base Compare
key_NUM || INIT_WHSE INIT_WHSE Diff. % Diff
|| _AMT _AMT
___________ || _________ _________ _________ _________
||
L0051041044 || 100.2340 12 . .
L0053125829 || 99.9700 . . .
L0053855466 || 98.2790 . . .
L0061072864 || 99.9990 . . .
L0061288205 || 99.1050 134 . .
L0062343827 || 98.5080 . . .
L0062526348 || 100.2340 . . .
L0063725295 || 98.9560 . . .
L0064004237 || 98.9560 . . .
L0064723026 || 99.2930 213 . .
|| Base Compare
key_NUM || FNL_PIPLN FNL_PIPLN Diff. % Diff
|| _AMT _AMT
___________ || _________ _________ _________ _________
||
L0051041044 || 100.2340 . . .
L0053125829 || 99.9700 . . .
L0053855466 || 98.2790 . . .
|| Base Value Compare Value
key_Num || FNL_PIPLN_EXIT_RSN_C FNL_PIPLN_EXIT_RSN_C
|| D D
___________ || _ _
||
L0051041044 || C
L0053125829 || C
L0053855466 || C
L0061072864 || C
L0061288205 || C
L0062343827 || C
L0062526348 || C
L0063725295 || C
L0064004237 || C
L0064723026 || C
$ awk -f extract.awk base_compare.txt
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,17103
FNL_PIPLN_EXIT_DT,17303,17203
FNL_PIPLN_EXIT_DT,17303,23201
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
INIT_WHSE_AMT,100.2340,12
INIT_WHSE_AMT,99.9700,.
INIT_WHSE_AMT,98.2790,.
INIT_WHSE_AMT,99.9990,.
INIT_WHSE_AMT,99.1050,134
INIT_WHSE_AMT,98.5080,.
INIT_WHSE_AMT,100.2340,.
INIT_WHSE_AMT,98.9560,.
INIT_WHSE_AMT,98.9560,.
INIT_WHSE_AMT,99.2930,213
FNL_PIPLN_AMT,100.2340,.
FNL_PIPLN_AMT,99.9700,.
FNL_PIPLN_AMT,98.2790,.
FNL_PIPLN_AMT,Base,Value
FNL_PIPLN_AMT,FNL_PIPLN_EXIT_RSN_C,FNL_PIPLN_EXIT_RSN_C
FNL_PIPLN_AMT,D,D
FNL_PIPLN_AMT,_,_
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
FNL_PIPLN_AMT,C,
$