Using Awk Script

Shell Programming and Scripting
1

Item #: 1
STATUS REPORT FOR JOB: Ftp
Generated: 2007-04-13 20:43:42
Job start time=2007-04-13 20:42:18
Job end time=2007-04-13 20:42:26
Job elapsed time=00:00:08
Job status=1 (Finished OK)

Item #: 2
STATUS REPORT FOR JOB: Ftp1
Generated: 2007-04-13 20:43:42
Job start time=2007-04-13 20:42:18
Job end time=2007-04-13 20:42:26
Job elapsed time=00:00:08
Job status=1 (Finished OK)

Item #: 3
STATUS REPORT FOR JOB: Ftp2
Generated: 2007-04-13 20:43:42
Job start time=2007-04-13 20:42:18
Job end time=2007-04-13 20:42:26
Job elapsed time=00:00:08
Job status=1 (Finished OK)

item.....

item ......

....................

awk 'BEGIN{ FS = "[=:]" }
/REPORT/ { ftp = $2 }
/Generated/ { generated = sprintf("%s:%s:%s", $2,$3,$4) }
/elapsed/ { elapsed = sprintf("%s:%s:%s", $2,$3,$4) }
/start time/ {start = sprintf("%s:%s:%s", $2,$3,$4) }
/end time/ {end = sprintf("%s:%s:%s", $2,$3,$4) }
/status/ { sub(/\(Finish.*/,"",$2); status=$2}
END {

printf "\%s\,\%s\,\%s\,\%s\,\%s\\n" , ftp,start,end,elapsed,status
}' "a.txt">b.csv

I used the above script to get the Items like

Ftp,2007-04-13 20:42:18,2007-04-13 20:42:26,00:00:08,1
Ftp1,2007-04-13 20:42:18,2007-04-13 20:42:26,00:00:08,1
Ftp2,2007-04-13 20:42:18,2007-04-13 20:42:26,00:00:08,1
how can i achieve this

2

You were pretty close. This worked for me... (and notice the single backslash in \n)

awk 'BEGIN{ FS = "[=:]" }
/REPORT/ { ftp = $2 }
/Generated/ { generated = sprintf("%s:%s:%s", $2,$3,$4) }
/elapsed/ { elapsed = sprintf("%s:%s:%s", $2,$3,$4) }
/start time/ {start = sprintf("%s:%s:%s", $2,$3,$4) }
/end time/ {end = sprintf("%s:%s:%s", $2,$3,$4) }
/status/ { sub(/\(Finish.*/,"",$2); status=$2}
$0 == "" {printf "\%s\,\%s\,\%s\,\%s\,\%s\n" , ftp,start,end,elapsed,status }
END {
printf "\%s\,\%s\,\%s\,\%s\,\%s\n" , ftp,start,end,elapsed,status
}'

3

You don't nead to use : as a field separator.

awk '
function print_datas() {
   if (ftp) printf("\%s,\%s,\%s,\%s,\%s\n" , ftp,start,end,elapsed,status);
   ftp=""
} 
BEGIN        { FS = "=" }
/^Item/      { print_datas() ; next}
/REPORT/     { ftp = $2 ; next }
/Generated/  { generated = $2 ; next }
/elapsed/    { elapsed = $2 ; next }
/start time/ { start = $2 ; next }
/end time/   { end = $2 ; next }
/status/     { status=int($2) ; next }
END          { print_datas() }
    ' a.txt > b.csv

Jean-Pierre.