I need to extract fields from this sas out put file.

[rknallamothu]

Hi
i have file like below i need to extract the values after the || and column name also ....here is that i need ..example . (FNL_PIPLN_EXIT_DT,1703,5) ,need to store into table. pls help me ,using ksh shell.


Value Comparison Results for Variables

_______________________________________
|| Base Compare
Ln_numbr || FNL_PIPLN FNL_PIPLN
|| _EXIT_DT _EXIT_DT
___________ || _________ _________
41041 || 17303 5
41042 || 17303 0
41043 || 17303 34
41045 || 17303 11
41046 || 17303 12
NOTE: The MAXPRINT=10 printing limre values will be printed for thisit has been
______________________________________
|| Base Compare
Ln_numbr || FNL_PIPLN FNL_PIPLN
||
___________ || _________ _________
L0051041044 || 100.00 5
L0051041044 || 17.0 0
L0051041044 || 17303 .
L0051041044 || 23.03 11
L0051041044 || 123.0 12

 

[PHV]

And what have you tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vgersh99]

rknallamothu,
pls stop posting to multiple sites leaching for solutions with no clear indication of the 'vested effort'!

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[rknallamothu]

i have red the rules.sorry.this posting only in this forum now.