Crop Variable Block file, header and trailer intact

Manu Dhawan · New User Joined: 01 Jun 2009 Posts: 9 Location: India

Hi,

I need to crop a VB file where I need to delete some columns, but the header and trailer record should not be changed in the output file. The trailer record can be identified using a key and header is always the first record. Is it possible in Sort?

I try to explain by example(Input and output are VB file):-

Input File:-

123456789HEADER
123456789RECORD1
123456789RECORD2
123456789RECORD3
.............................
.............................
123456789RECORDn
123456789TRAILER

Let say I need to detele columns 4 to 9.

Output File required as:-

123456789HEADER
123RECORD1
123RECORD2
123RECORD3
.............................
.............................
123RECORDn
123456789TRAILER

Thanks,
Manu

expat · Posted: Tue Jul 28, 2009 3:54 pm Post subject:

Take a look at the DFSORT tricks book HERE

Frank Yaeger · Posted: Tue Jul 28, 2009 9:00 pm Post subject:

Manu,

You can use a DFSORT job like the following to do what you asked for: