Removal of Heading in File



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Removal of Heading in File

Postby Ramsee » Wed Dec 24, 2014 7:31 pm

Hi All,

Warm greeting!!

My input File looks like as below
--------------------------------------------------------------------
              HEADING1                                     
--------------------------------------------------------------------
            (ABC)     (AASSDD) (DDDDEC) (CAAABA)    TOTAL   
PROCESSING  RECEIVED      ABC       ABC      XMIT START  PROCESSING
  DATE      FROM TSYS  START TIME  END TIME  TIME DWNSTRM   TIME     
----------  ---------  ----------  --------- ------------ ----------
MM/DD/YY    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS
----------  ---------  ----------  --------- ------------ ----------
11/18/14....03:38:00....03:38:00....03:52:00....03:52:30....00:14:30
11/19/14....02:52:00....02:52:00....02:56:00....02:56:30....00:04:30
11/20/14....03:25:00....03:25:00....03:33:00....03:33:30....00:08:30
--------------------------------------------------------------------
              HEADING2                                     
--------------------------------------------------------------------
            (ABC)     (AASSDD) (DDDDEC) (CAAABA)    TOTAL   
PROCESSING  RECEIVED      ABC       ABC      XMIT START  PROCESSING
  DATE      FROM TSYS  START TIME  END TIME  TIME DWNSTRM   TIME     
----------  ---------  ----------  --------- ------------ ----------
MM/DD/YY    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS
----------  ---------  ----------  --------- ------------ ----------
11/21/14....03:17:00....03:17:00....03:32:00....03:39:30....00:22:30
11/22/14....03:45:00....03:45:00....04:14:00....04:27:30....00:42:30
--------------------------------------------------------------------
              HEADING2                                     
--------------------------------------------------------------------
            (ABC)     (AASSDD) (DDDDEC) (CAAABA)    TOTAL   
PROCESSING  RECEIVED      ABC       ABC      XMIT START  PROCESSING
  DATE      FROM TSYS  START TIME  END TIME  TIME DWNSTRM   TIME     
----------  ---------  ----------  --------- ------------ ----------
MM/DD/YY    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS
----------  ---------  ----------  --------- ------------ ----------
11/22/14....05:11:00....05:11:00....05:11:00....05:12:30....00:01:30
11/23/14....02:47:00......:..:00......:..:00......:..:00....      00:00:00

Output File :
--------------------------------------------------------------------
              HEADING1                                     
--------------------------------------------------------------------
            (ABC)     (AASSDD) (DDDDEC) (CAAABA)    TOTAL   
PROCESSING  RECEIVED      ABC       ABC      XMIT START  PROCESSING
  DATE      FROM TSYS  START TIME  END TIME  TIME DWNSTRM   TIME     
----------  ---------  ----------  --------- ------------ ----------
MM/DD/YY    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS    HH:MM:SS
----------  ---------  ----------  --------- ------------ ----------
11/18/14....03:38:00....03:38:00....03:52:00....03:52:30....00:14:30
11/19/14....02:52:00....02:52:00....02:56:00....02:56:30....00:04:30
11/20/14....03:25:00....03:25:00....03:33:00....03:33:30....00:08:30
11/21/14....03:17:00....03:17:00....03:32:00....03:39:30....00:22:30
11/22/14....03:45:00....03:45:00....04:14:00....04:27:30....00:42:30
11/22/14....05:11:00....05:11:00....05:11:00....05:12:30....00:01:30
11/23/14....02:47:00......:..:00......:..:00......:..:00....      00:00:00

I need to remove the heading 2 and heading 3 in a sortcard, down the time heading 4 and heading 5 may also be included in the input file,but my output should have only HEADING 1 and remaining HEADING should be supressed.

Kindly guide me how to proceed further.

Thanks in Advance.
Ramsee
Ramsee
 
Posts: 25
Joined: Wed Nov 20, 2013 6:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Removal of Heading in File

Postby BillyBoyo » Wed Dec 24, 2014 10:05 pm

You need to create an OMIT COND= which will match each of the lines you don't want, but which won't match anything else.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post