Need help to make a csv file

Hi All :slight_smile:

Need help to create a csv file from some data which is extracted from input file

Input file:

 1.  RUN DATE: 06/02/11  2. SYSTEM: EP0Z       3. PROBLEM TYPE: 0016
               --------             ----                        ----
 4.  JOB NUMBER: 4301    5. JOB NAME: EP0Z080P 6. STEPNAME: EPZSTP06
                 ----                 --------              --------

 7.  TIME NOTIFIED: 23:55      8. WHO NOTIFIED: CHINMAY SAHOO
                    -------                     --------------------
                       9. HELPERS:  ABEND.DATA
                                   ---------------------------------


 10. WHAT WAS WRONG?:

     CC 16 IN EPZSTP06 PROGRAM EPZ00080


     ERROR ON SECTION : 24701-DEP-PROD-VR-CHECK
     ERR MSG : SELECT MSHP CH MCURS        SQL CD : -180
     SUBS ID : 072426609


 11. HOW WAS THIS PROBLEM HANDLED?:
      COPIED THE PROD FILE 'EP00P.EPZ00080.INPUT.TRIGG(0)'
      TO TEST FILE 'EP00T.EPZ00080.INPUT.TRIGG.G2310BKP'.
      BELOW PROCESS WAS FOLLOWED
    A. WE SEARCHED FOR THE SUBSCRIBER WHICH HAS SHOWN IN SYSOUA
       DURING FIRST ABEND SUBS ID : 72426609
    B. WE THEN FIND OUT THE SUBS ID WHICH WAS BEFORE THIS SUBSID AND
       HAVE RECTYPE AS 'SP'.ALL RECORDS FOR THIS SUBSCRIBER ID WITH REC
       TYPE SP WERE  REMOVED.

I want to cut RUN DATE, WHAT WAS WRONG details and SQL CD which is SQL code and create a csv file from these 3 data.

please help

Can you post the output format required..?

Can anybody tell me. even i am facing the same issue..

what issue ?

post the sample input file and sample output format

Output file is look like

06/02/11,  CC 16 IN EPZSTP06 PROGRAM EPZ00080 ERROR ON SECTION : 24701-DEP-PROD-VR-CHECK LECT MSHP CH MCURS SQL CD : -180 SUBS ID : 072426609 , -18

this type of file I need