|
View previous topic :: View next topic
|
| Author |
Message |
David Sde
New User
Joined: 24 Apr 2011
Posts: 23
Location: USA
|
|
|
|
Hi,
I have an FB 80 dataset, from which I would like to remove the second and third record from the end. E.g.:
| Code: |
Input:
AAA
BBB
...
YYY
ZZZ
TRAILER
Output:
AAA
BBB
...
TRAILER
|
The documentation makes me think this isn't doable using SUBSET... might I be missing something? Is there another approach I can take?
Any help would be appreciated; thank you!
David |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
SUBSET is not going to do it for you directly.
IF you knew the record-numbers of the records you wanted to drop, or could identify them by something other than their position, then SUBSET/something else would do you.
However.
What is in the trailer? It would be possible to drop the last three records, then add a TRAILER1 on OUTFIL, if all the data to make the TRAILER1 is available (or can be made available). |
|
| Back to top |
|
|
David Sde
New User
Joined: 24 Apr 2011
Posts: 23
Location: USA
|
|
|
|
| Quote: |
| What is in the trailer? It would be possible to drop the last three records, then add a TRAILER1 on OUTFIL |
Yes! That's the answer; the trailer record is a constant. Perfect; thank you!
David |
|
| Back to top |
|
|
|
|
