Updated files using awk

Shell Programming and Scripting
1

If third column contains null value then it should delete the row and i want to know the files which contains null value in 3rd column.Below code is not showing the updated files correctly..not sure what the issue is.plz help me

#!/usr/bin/sh
Scripts=/ushhquest/data001/Scripts

cd /ushhquest/data011/TgtFiles/MonthlyData
ls CUSTADDR*.txt > sample_txt_files
while read line
do
srcfile="/ushhquest/data012/TgtFiles/BMMonthlyData"$line
tgtfile=/ushhquest/data012/TgtFiles/BMMonthlyData/output.txt
awk -F, '$3 =="" {next;}1' $srcfile >> $tgtfile
if [[ $(awk -F, '$3 =="" {print;exit}' $srcfile) ]]
then
echo $srcfile >> output_file # Here you get all the files which has $3 blank
fi
#rm -f $srcfile # You don't need rm here...
mv $tgtfile $srcfile
done<sample_txt_files
rm -f sample_txt_files
echo "completed"
2

Modification:-

if [ $(awk -F, '$3 =="" {print;exit}' $srcfile) ]; then
 echo $srcfile >> output_file
fi
3

also try replacing:

if [[ $(awk -F, '$3 =="" {print;exit}' $srcfile) ]]
then
echo $srcfile >> output_file # Here you get all the files which has $3 blank
fi

with:

awk -F, '$3 =="" {print FILENAME;exit}' $srcfile >> output_file
4

Getting error as :Syntax error at line 12: ']]' is not expected.when using below code

if [[ $(awk -F, '$3 =="" {print;exit}' $srcfile) ]]
then
echo $srcfile >> output_file # Here you get all the files which has $3 blank
fi

---------- Post updated at 03:33 PM ---------- Previous update was at 03:32 PM ----------

if [ $(awk -F, '$3 =="" {print;exit}' $srcfile) ]; then
 echo $srcfile >> output_file
fi

not showing correct file names.

---------- Post updated at 03:34 PM ---------- Previous update was at 03:33 PM ----------

awk -F, '$3 =="" {print FILENAME;exit}' $srcfile >> output_file.where i want to replace the line from below code.

#!/usr/bin/sh
Scripts=/ushhquest/data001/Scripts

cd /ushhquest/data011/TgtFiles/MonthlyData
ls CUSTADDR*.txt > sample_txt_files
while read line
do
srcfile="/ushhquest/data012/TgtFiles/BMMonthlyData"$line
tgtfile=/ushhquest/data012/TgtFiles/BMMonthlyData/output.txt
awk -F, '$3 =="" {next;}1' $srcfile >> $tgtfile
if [[ $(awk -F, '$3 =="" {print;exit}' $srcfile) ]]
then
echo $srcfile >> output_file # Here you get all the files which has $3 blank
fi
#rm -f $srcfile # You don't need rm here...
mv $tgtfile $srcfile
done<sample_txt_files
rm -f sample_txt_files
echo "completed"

5

Not showing correct files means what....???

Which file names you want $srcfile or $tgtfile ???

6

Sorry for the confusion boss ,I did mistake while copying the code ....thanks for your help