UNIX for Dummies Questions & Answers

I have a file with follwing content
----------------------------------
SCHEDULE XXXXXXXXX#JOBCOUNT
ON EVERYDAY
AT 0000
PRIORITY 50
SCHEDULE XXXXXXXXX#ABCDEFGH
ON EVERYDAY
AT 0001
PRIORITY 29
SCHEDULE XXXXXXXXX#ABCD1234
ON EVERYDAY
AT 0002
PRIORITY 40
SCHEDULE XXXXXXXXX#12345678
ON EVERYDAY
AT 0003
PRIORITY 56
----------------------------------
Now, I want to generate output like below

JOBCOUNT| EVERYDAY |0000|50
ABCDEFGH| EVERYDAY |0001|29
ABCD1234| EVERYDAY |0002|40
12345678|EVERYDAY |0003|56

and put this output in other file.

Can someone help me ? please ....

Thanks..

Code:

#!/bin/sh

i=0
cat input | while read line
do
   case $i in
      0) str1=`echo $line | awk -F'#' '{print $2}'`;;
      1) str2=`echo $line | awk -F'ON' '{print $2}'`;;
      2) str3=`echo $line | awk -F'AT' '{print $2}'`;;
      3) str4=`echo $line | awk -F'PRIORITY' '{print $2}'`;;
      4) i=0;
         str=`echo $str1 \| $str2 \| $str3 \| $str4`;
         echo $str;;
   esac
   i=`expr $i + 1`
done

Output:
JOBCOUNT | EVERYDAY | 0000 | 50
JOBCOUNT | EVERYDAY | 0001 | 29
JOBCOUNT | EVERYDAY | 0002 | 40

Hope this helps.

With one awk command:

Code:

awk -F" |#" '/^SCHEDULE/{
  s=$3
  getline;s=s"|"$NF
  getline;s=s"|"$NF
  getline;s=s"|"$NF
  print s
}' file

/usr/xpg4/bin/awk '/PRIORITY/{print;next}NF{printf("%s ",$0)}' file |cut -d "#" -f2 | cut -d ' ' -f1,3,5,7 |awk -F" " '{print $1 , "|"$2 ,"|"$3 ,"|"$4}'

Yet another one with awk:

(use gawk, nawk or /usr/xpg4/bin/awk on Solaris)

Code:

awk '{ sub(/.*#/, ""); $0 = $NF }
ORS = NR % 4 ? OFS : RS' OFS=\| infile

Thank you all.....