Copy only the last record from input to output.

[Ameya C]

Hi,

I have a VBS file from which I need to get the first record and last record in the output file. I used STOPAFT=1 but it helps to get the first record. But I am not sure how to get the last record only.

Can you please tell me how to get only the last record from a VBS file using SORT.

Thanks,

[William Collins]

Use JOINKEYS with the same dataset. JOIN UNPAIRED,F1,F2,ONLY. REFORMAT statement including the entire F1 and F2 and the match-markers (?). Depending on value of match-marker, BUILD correct output.The key for the JOINKEYS is an extension to the record containing a sequence number (large enough to be unique for each record in the file). This will be set in the JNFnCNTL files. For one sequence number use START=0, for the other use START=1.

[William Collins]

Or, for less code and excitement, look at ICETOOL's SUBSET operator.

[zprogrammer]

Or even OUTFIL NODETAIL with TRAILER

[William Collins]

Yes, like this:

Code: Select all

  OUTFIL HEADER1=(1,80),
         TRAILER1=(1,80),
         REMOVECC,
         NODETAIL

The other two are more flexible, as different numbers of "first" and "last" records could be processed (or ignored).

[zprogrammer]

Ok Thanks William