Extract
Posted: Tue Feb 09, 2016 2:31 am
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.
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.