Shell Programming and Scripting

sed -i 's/"//g' test.txt
printf "IDN|emp_name|emp_sal|emp_value\n" >> ouput1.txt
while read -r line
do
id=`echo $line | grep -o '^[0-9]\+'`
printf "$id|"
if [[ $line =~ emp_name ]]
then
emp_nm=`echo $line | grep -o 'emp_name:\w\+'`
emp_nm_val=`echo $emp_nm | cut -d: -f2`
printf "${emp_nm_val}|"
else
printf "xxx|"
fi

if [[ $line =~ emp_sal ]]
then
emp_sal=`echo $line | grep -o 'emp_sal:\w\+'`
emp_sal_val=`echo $emp_sal | cut -d: -f2`
printf "${emp_sal_val}|"
else
printf "xxx|"
fi

if [[ $line =~ emp_value ]]
then
emp_value=`echo $line | grep -o 'emp_value:\w\+'`
emp_value_val=`echo $emp_value | cut -d: -f2`
printf "${emp_value_val}\n"
else
printf "xxx|\n"
fi

done < test.txt >> ouput1.txt

awk 'BEGIN {print"IDN|cust_com|cust_value"}{n=split($0,a,"|");
        for(x=1;x<n+1;x++)
                { if(a[x]~/\[\[/)
                        {gsub(/[][]/,"",a[x]);
                        gsub(/:/,"|",a[x]);
                         print a[1]"|"a[x]}}}
                        ' test.txt  >> ouput2.txt