Shell Programming and Scripting

Name  : sdt2156157_ID
       NOS : 4567 [ sdt2156157/67 ]
       NOS : 2348 [ sdt2156157/48 ]  
Name  : sdt2156158_ID
       NOS : 4987 [ sdt2156158/87 ]
       NOS : 2332 [ sdt2156158/32 ]

while read line
do
nos=$(echo $line|grep NOS|awk '{print $3}')
name=$(echo $line|awk '{ if ($1 == "Name") print $5}')

echo $name
echo "INSERT -name $name -nos $nos to chart ABC;"

done < filename1

sdt2156157_ID
INSERT -name mdt2156157_ig -nos to chart ABC;

INSERT -name -nos 4567 to chart ABC;

INSERT -name -nos 2348  to chart ABC;

sdt2156157_ID
INSERT -name mdt2156157_ig -nos 4567 to chart ABC;
INSERT -name mdt2156157_ig -nos 2348  to chart ABC;

#!/usr/bin/someposixshell ksh, bash, dash, ...

# make tmp file for input
cat <<EOF > $0.tmp
Name : sdt2156157_ID
NOS : 4567 [ sdt2156157/67 ]
NOS : 2348 [ sdt2156157/48 ]
Name : sdt2156158_ID
NOS : 4987 [ sdt2156158/87 ]
NOS : 2332 [ sdt2156158/32 ]
EOF

# ver 1 using shell
# set fld delimiter
IFS="${IFS}:]["
name=""
action="INSERT"
while read key id value x
do
        case "$key" in
                Name) name="$id" ; echo $name ; action="INSERT" ;;
                NOS) echo "$action -name $name -nos $id to chart ABC;"  ; action="APPEND";;
        esac
done < $0.tmp

# ver 2 using awk
awk  '
$1 == "Name" { name=$3 ; print name ; action="INSERT";  next }
$1 == "NOS" {
        print action," -name ",name," -nos",$3," to chart ABC;"
        action="APPEND"
        }
' $0.tmp

rm -f $0.tmp 2>/dev/null

sdt2156157_ID
INSERT -name mdt2156157_ig -nos 4567 to chart ABC;
APPEND -name mdt2156157_ig -nos 2348 to chart ABC;