converting mqsilist output to a csv file

 #!/bin/bash

RESFILE="/home/priyesh.singh/scripts/flow-list/ACE_Flow_Details.csv"

WORKDIR="/home/priyesh.singh/scripts/flow-list"

echo "App-Flow, EG, Status" >> $RESFILE

grep -i ": Application" $WORKDIR/ACE_App_list.txt >> $WORKDIR/ACE-flow-List-Nov-2024.txt

while read templine; do

AppName=`echo $templine | cut -d":" -f2 | cut -d"'" -f2`

EGName=`echo $templine | cut -d":" -f2 | cut -d"'" -f4`

Status=`echo $templine | cut -d" " -f9 | cut -d"." -f1`

echo "$AppName, $EGName, $Status" >>$RESFILE

done < $WORKDIR/ACE-flow-List-Nov-2024.txt

#rm $WORKDIR/ACE_App_list.txt

#rm $WORKDIR/ACE_AppTemp_list.txt