Page 1 of 1

Omit lines between Low and High range.

PostPosted: Fri Apr 09, 2010 6:52 pm
by polamjeevan
Hi
I need immediate help from you on removing the lines between Low and High values.
For example I have a dataset like
abc1254.01.12.37
abc1254.01.12.38
abc1254.01.12.39
abc1254.01.12.40
abc1254.01.13.13
abc1254.01.13.14
abc1254.01.13.15
abc1254.01.13.16
In this i want to delete the Lines between Low and High value.
The final o/p should be like
abc1254.01.12.37
abc1254.01.12.40
abc1254.01.13.13
abc1254.01.13.16
Please help me on this. Thankyou.

Re: Omit lines between Low and High range.

PostPosted: Fri Apr 09, 2010 8:54 pm
by Frank Yaeger
How are you "grouping" the records? By positions 1-13, or some other way? How exactly?

What is the RECFM and LRECL of the input file?

Are the input records already in sorted order as shown in your example?

Re: Omit lines between Low and High range.

PostPosted: Sun Apr 11, 2010 4:14 pm
by polamjeevan
No the records are not in sort order, i thought to apply the sort function before grouping records by position 1-16 chars
Input file of Recfm FB of length 80.

Re: Omit lines between Low and High range.

PostPosted: Mon Apr 12, 2010 10:27 pm
by Frank Yaeger
i thought to apply the sort function before grouping records by position 1-16 chars


If you group the records by 1-16, then the low value would be:

abc1254.01.12.37

and the high value would be:

abc1254.01.13.16

but that's not what you show as the expected output. You need to do a better job of explaining the "rules" for getting from input to output before anyone can help you.