Shell Programming and Scripting

### 1-Using SED to remove lines and other data to simplify #####
#################################################################
sed -e '
s/\(.*_[a-zA-Z]*\)\( .*\)/\1/;
s/^Atomic.*//;
s/^Condition.*//;
s/^SUCCESS(.*//;
s/^-.*//;
s/^_.*//;
s/\(^Job Name\)\( .*\)/\1/;
s/\(^Dependent Job Name\)\( .*\)/\1/;
/./!d' inputfile | 
####2-Using AWK to merge lines after pattern "Dependent Job Name"###
#################################################################

awk 'BEGIN{print "Job Name|Dependent Job Name"}
{
if ( $0~/Dependent Job Name/ || $0~/.*_.*/ )
printf("%s,", $0)
else
printf(" %s\n", $0)
}' > temp 
####3-Using SED to remove extra words to match the requirements #######
#################################################################
sed -e '
s/,Dependent Job Name,/|/;
s/Start Dependent//;
2,$s/Job Name//;
s/^[ \t]*//;
s/[ \t]*$//;
/./!d
s/,$//' temp > outputfile
rm temp

Job Name|Dependent Job Name
DWC$DAC103_acct_naked_opt|RDS$DAC524_D_DWC_AC_NKDO_FACT,WST$DAC437_R037_Uncovered_Opt
DWC$DAC104_acct_position|RDS$DAC504_D_DWC_AC_POS,RDS$DAC504_D_DWC_BRN_POS_FACT,RDS$DAC504_D_DWC_FA_POS_FACT,WST$DAC414_Cap_Limit_Master,WST$DAC427_R017_TAPS,WST$DAC441_R043_Error_Act_Pos,WST$DAC444_R052_B_Share_Pos,WST$DAC446_R054_C_Share_Pos,WST$DAC452_R064_FDIC_Exposure,

/* ----------------- DWC$DAF101_VALUSTRT.DAT ----------------- */

insert_job: DWC$DAF101_VALUSTRT.DAT   job_type: f
term_run_time: 1320
watch_interval: 60

/* ----------------- DWC$DAF102_E99MSGSTRT.DAT ----------------- */

insert_job: DWC$DAF102_E99MSGSTRT.DAT   job_type: f
watch_interval: 60

insert_job|job_type|term_run_time|watch_interval
DWC$DAF101_VALUSTRT.DAT|f|1320|60
DWC$DAF102_E99MSGSTRT.DAT|f|1320|60

awk -F": " 'BEGIN{print "insert_job|job_type|term_run_time|watch_interval"}
{sub(/[ \t]+$/, "")}
{sub(/[ ]*job_type/,": job_type",$0)}
/insert_job/{a=$2}
/job_type/{b=$4}
/term_run_time/{c=$2}
/watch_interval/{d=$2;print a,b,c,d; a="";b="";c="";d=""}
' OFS="|" inputfile