format a file to this output

Shell Programming and Scripting
1

hi

i need some help over here.. please help

i have a log file as per below

---------------------------------------------------------------------------------------------------------
JOB START DATE     : 20110510204513
JOB ID             : us2cap3ds9
-------------------------------------------------------------------------
Entering Post Processes...
LOG DIRECTORY    : /batch_dir/batch/us2cap3ds9/log
JOB PID          :
JOB END DATE     : 20110510205141
Job Exit Code    : 1
-------------------------------------------------------------------------
Process completed with WARNING.
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
Job directory found!
Job Ini File for this job: /apps_dir/arbor/custom/conf/abc_us2cap3ds9.ini
Bypassing the App INI file. (/apps_dir/arbor/custom/conf/abc_fn_us2cap3ds9.ini)
Running Job in MULTI STREAM mode.

---------------------------------------------------------------------------------------------------------
JOB START DATE     : 20110510214512
JOB ID             : us2cap3ds9
-------------------------------------------------------------------------
Entering Post Processes...
LOG DIRECTORY    : /batch_dir/batch/us2cap3ds9/log
JOB PID          :
JOB END DATE     : 20110510215224
Job Exit Code    : 1
-------------------------------------------------------------------------
Process completed with WARNING.
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
Job directory found!
Job Ini File for this job: /apps_dir/arbor/custom/conf/abc_us2cap3ds9.ini
Bypassing the App INI file. (/apps_dir/arbor/custom/conf/abc_fn_us2cap3ds9.ini)
Running Job in MULTI STREAM mode.

---------------------------------------------------------------------------------------------------------
JOB START DATE     : 20110510224512
JOB ID             : us2cap3ds9
-------------------------------------------------------------------------
Entering Post Processes...
LOG DIRECTORY    : /batch_dir/batch/us2cap3ds9/log
JOB PID          :
JOB END DATE     : 20110510225230
Job Exit Code    : 1
-------------------------------------------------------------------------
Process completed with WARNING.
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
Job directory found!
Job Ini File for this job: /apps_dir/arbor/custom/conf/abc_us2cap3ds9.ini
Bypassing the App INI file. (/apps_dir/arbor/custom/conf/abc_fn_us2cap3ds9.ini)
Running Job in MULTI STREAM mode.

---------------------------------------------------------------------------------------------------------
JOB START DATE     : 20110510234513
JOB ID             : us2cap3ds9
-------------------------------------------------------------------------
Entering Post Processes...
LOG DIRECTORY    : /batch_dir/batch/us2cap3ds9/log
JOB PID          :
JOB END DATE     : 20110510235047
Job Exit Code    : 1
-------------------------------------------------------------------------
Process completed with WARNING.
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
Job directory found!
Job Ini File for this job: /apps_dir/arbor/custom/conf/abc_us2cap3ds9.ini
Bypassing the App INI file. (/apps_dir/arbor/custom/conf/abc_fn_us2cap3ds9.ini)
Running Job in MULTI STREAM mode.

---------------------------------------------------------------------------------------------------------
JOB START DATE     : 20110511004511
JOB ID             : us2cap3ds9
-------------------------------------------------------------------------
Entering Post Processes...
LOG DIRECTORY    : /batch_dir/batch/us2cap3ds9/log
JOB PID          :
JOB END DATE     : 20110511005000
Job Exit Code    : 1
-------------------------------------------------------------------------
Process completed with WARNING.
---------------------------------------------------------------------------------------------------------

what i want to do is to massage the log file to the following output

JOB START DATE          JOB END DATE
20110510204513        20110510205141
20110510214512        20110510215224
20110510214512        20110510215224

and so on.....
2

Try this

 awk -F: 'BEGIN{print " JOB START DATE  JOB END DATE"}/JOB START DATE/{x=$2} /JOB END DATE/{print x" "$2}' logfile

regards,
Ahamed

3

script aa.sh

output=`cat /usr/opt/autotree/joblogs/BATCH/us2cap3ds9.out | awk -F: 'BEGIN{print " JOB START DATE JOB END DATE"}/JOB START DATE/{x=$2} /JOB END DATE/{print x" "$2}'`
$output

error
aa.sh[2]: JOB: not found.

please help

4

Please use code tags

Try this

output=`cat /usr/opt/autotree/joblogs/BATCH/us2cap3ds9.out | awk -F:  'BEGIN{print " JOB START DATE  JOB END DATE"}/JOB START DATE/{x=$2} /JOB  END DATE/{print x" "$2}'`
echo -e "$output"

Even if you want to put in a script, just use it like this

#!/bin/bash
 awk -F: 'BEGIN{print " JOB START DATE  JOB END DATE"}/JOB START DATE/{x=$2} /JOB END DATE/{print x" "$2}' logfile

regards,
Ahamed

5 
 awk 'BEGIN{print "JOB START DATE JOB END DATE"} /JOB START DATE :/{printf $NF FS}/JOB END DATE :/{print $NF}' file
6 
foreach $line(@file){
  if ($line =~ s/\w+\sSTART\s\w+\s:\s(\d+)/$1/) {print "Job Start Date, $1\n"; }
  if ($line =~ s/\w+\sEND\s\w+\s:\s(\d+)/$1/) {print "Job End Date, $1\n"; }
  }
7

thanks for the help all... love you guys..