Page 1 of 1

Extract

Posted: Tue Feb 09, 2016 2:31 am
by pawan.konduru
Hi,
can someone do the needful,

I have a file with the below inforamtion, i need to extract the 4 lines from the file when the Pos: 4 to 6 bytes of line 1 have the value G1151C and a value 000-59929 in Line-3 Pos 1 9

1 xxxG1151C
2 034
3 000-59929
4 9896.00
1 xxx G1151B
2 0565
3 000-58053
4 1235.00
1 xxxG1151C
2 025
3 000-59111
4 3659.00
1 xxxG115C
2 000
3 000-59929
4 123.55

o/p should be
1 xxxG1151C
2 034
3 000-59929
4 9896.00
1 xxxG115C
2 000
3 000-59929
4 123.55

Can this be possible in Sort/Sync Sort.

Posted: Tue Feb 09, 2016 2:39 pm
by William Collins
What is the LRECL and RECFM?

Posted: Thu Feb 11, 2016 12:27 am
by pawan.konduru
RECL=80, RECFM=FB